Current requirements: The output required is a pivot table with :
Dim1:Top N Countries based on Sales on selected Month.
Dim2: Year 1 and Year 2 (based on user selection)
DIm 3: Periods in the form of 4 Quarters Ago, 3 Quarters Ago, 2 Quarters Ago, 1 Quarter Ago, YTD, MTD, Previous Month, 2months ago appearing at the same time where Year depends on Dim2
Dim 4: Bucketing of Sales: e.g. All Range, 0-$300, 300-600, 0-600. Range can be dynamic based on user input.
Dim 5: Materials in this format:
Material 1
Material 2
Material 3
Material 4
Material 5
Material 6
Material 7
Where Material 1 is the latest Material for that country
Material 2 is the top selling Material for that country except Material 1
Material 3 is the top selling Material for that country except Material 1 and Material 2
Material 4 is the TOTAL of all Materials flagged as "Special"
Material 5 is the top Material flagged as "Special" but not Material 1, Material 3 and Material 4
Material 6 is the 2 top Material flagged as "Special" but not Material 1, Material 3 and Material 4 and Material 5
Material 7 is the top 1 Material NOT flagged as "Special" but not Material 1, Material 3 and Material 4
Everything is working with valuelist() then comes Dim6 as the new requirement
Dim6: Categorized Dim3 if "Quarterly", "Yearly" or "Monthly"
