hi..... i have a pivot table with dimensions Period, Actuality(AC,BU), and CompanyCode and expressions some of valuesX and sum of valuesY.
so
- 1. When select Year and Month, Pivot Table will display Actual (AC) and Budget (BU) values of the selected period and only Actual (AC) value of previous period corresponding to the selected Year and Month.
For example,
- When Year 2013 and Month 8 are selected, Pivot Table will display AC 201307, AC 201308, and BU 201308 of both expressions
- When Year 2013 and Month 7 are selected, Pivot Table will display AC 201306, AC 201307, and BU 201307 of both expressions
- so on and so forth.