pivot table question

venkanna_info — Mon, 12 Jun 2017 10:32:15 GMT

hi..... i have a pivot table with dimensions Period, Actuality(AC,BU), and CompanyCode and expressions some of valuesX and sum of valuesY.

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.

topic Re: pivot table question in QlikView