I am looking to produce a Pivot Chart so am currently pulling together the Pivot Table. However, I have encountered a problem which I'm hoping there is a straightforward solution to. I have attached a simplistic example of my data.
I want to be able to SUM the values of 'Pass' and 'Pass (Minor Error)' for each row and then display this value as a % of the row total. I.e. February would be (3+1)/5 = 80%. I hoped to achieve this using the 'Calculated Item' function but it appears you cannot do this when dates have been grouped like they have in my Pivot Table.
Any assistance would be greatly appreciated. Thanks in advance!
Bookmarks