Hi,
Need help in getting the below requirement.
In a single QVW, one pivot should generate detailes of all Regions and all runs data. In another tab of same QVW, another pivot should show the consolidated report which should consider each regions latest run data.
Sample Data:
Region, Type, Run, Amounts
A, Base, 1, 100
A, Base, 2, 200
A, Stress, 1, 200
A, Stress, 2, 300
A, Stress, 3, 300
B, Base, 3, 40
B, Base, 4, 50
B, Stress, 3, 60
C, Base, 1, 20
C,Base, 4, 30
C, Stress, 2, 20
The QVD stores all the data. From that, regular pivot showsall runs details
But, a consolidation report should show the latest run details against Region and Type.
Consolidation View:
Region, Type, Run, Amount
A, Base, 2, 200
A, Stress, 3, 300
B, Base, 4, 50
B, Stress, 3, 60
C, Base, 4, 30
C, Stress, 2, 20
How can i achieve the consolidation report? How can i filter the data based on latest Run against Region and Type at Pivot level? Please guide me here. Thanks in Advance.
