Is it possible to create a pivot chart to get the grand total subtract from 100% (eg 660), and also place a target line (eg 89% of 660 = 587), and a 100% line on the graph.
The result at the moment is the sum of a number of minutes per day. (eg 25) (This is calculated by the pivot table)
So I would like that I see 635 in stead of 25, and if it is possible that this number is converted to 96% from 660 in the displays.
The problem, for me, is that 25 is a calculated number and not directly from the data retrieved. How can I use the calculated data, and use the result.
Attached the file with the PivotChart and data.
Thanks for helping,