From the given data source (fact.qvd), please create QV Application with List Boxes and Pivot Table which looks and behaves as per described below:
- 1. List Box of Year and Month
- 2. Pivot Table which contains and is arranged as above picture
- 2.1. Dimensions of Period, Actuality, and CompanyCode
- 2.2. Expressions of sum of ValueX and ValueY
- 3. 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.
- 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
Any technique/option/setting which should be applied to make the application work properly, please do not hesitate to do so.
Kindly help me on the 3rd Scenario.