Quote:
Originally Posted by Co-op Bank
Hello,
I have a list of data with three columns, these are 'Period', 'Area' and
'Cost'.
I want to pivot to show the area's listed down vertically, the period
horizontally across and the 'Grand Total' inserted in the pivot table to give
an average of the periods instead of the sum. Is this possible?
Please advise, much appreciated.
Brian Taylor
Manchester, England.
|
Hi Brian,
You can do it creating a calculated field in a Pivot Table created with Powerpivot.
You need to write the calculation in DAX.
However, the correct result depends on how you present the data on the Pivot Table.
Best,
Paolo