Below is a snip of my pivot table. I added the underlying table to the data model for the workbook, for sorting reasons mostly.
I'm wanting to get a % calculation of Total Made/Total Planned. I cannot get the calculation to work. I've added a calculated column in the data model, which isn't right, as it (predictably) sums the %'s in each pivot row. On row 1, the % Total Made to Total Planned would be 86%. The Nov Total would calculate to 99.3%, Dec Total would be 100.7% etc.
Thanks in advance for any help you wizards can give me here.
MB
The underlying table
I'm wanting to get a % calculation of Total Made/Total Planned. I cannot get the calculation to work. I've added a calculated column in the data model, which isn't right, as it (predictably) sums the %'s in each pivot row. On row 1, the % Total Made to Total Planned would be 86%. The Nov Total would calculate to 99.3%, Dec Total would be 100.7% etc.
Thanks in advance for any help you wizards can give me here.
MB
The underlying table