Help doing some calculations within pivot table

ricklinty,

• a nice tutorial for adding measures in the Data Model!
• the only thing I might have done differently is use your prior created measures

Help doing some calculations within pivot table

https://www.contextures.com/excel-pi...ted-field.html...

Formula help

Hello,

I am going to attach the sheets for reference!

This is sheet 1



This is sheet 2

...

Help doing some calculations within pivot table

First you need to make your raw data into a Table, Ctrl + T is the shortcut.
Then insert a pivot table by selecting the table above. Tick the "Add...

Please assist with a split text to columns formula

And here: https://www.excelforum.com/excel-gen...el-2013-a.html...