I have a pivot chart that has several dimension (year/month/region/state) and two measures (Sales/Units). The measures are set to a toggle where when SALES is selected from the toggle filter - only the sales figures show - pivoted by month. Similarly, when Units is selected in a toggle filter, only the UNITS display - pivoted by month.
The challenge is to define the sub-total calculation. When Sales is displayed - the subtotal formula should be set to SUM. When UNITS are displayed, the sub-total formula should be set to AVERAGE.
This is the display I am looking for. The Sub-Total across Rows (2014-15.67) is perfect. I am looking for the column sub-totals to be the Total (month 1 – should be 37).
Thanks. Marking the response as correct.
Thomas Berard | PMO Consultant | Global Technology, RAD-Americas Planning & Effectiveness |<https://team.amer.mymetlife.com/Teams/bmosecure/default.aspx>
To submit Service Requests click here for Assist<https://team.amer.mymetlife.com/Teams/IBITPMO/Web%20Part%20Page%20Library/SN%20in%20Connect.aspx?PageView=Shared&InitialTabId=Ribbon.WebPartPage&VisibilityContext=WSSWebPartPage>
