Hi Team, I have a module with Location as a dimension and line items Sales, Profit, Expenses, Opex and Margin. I want to create a Dashboard or Dynamic Report where these line item will be Page Selectors and the locations will be published based on the selection , sequenced and filtered with TOP 5 values. For Example : Scenario 1- If I select Sales , the Grid should show only TOP 5 Locations based on the sales. Sales Loc 1 1000000 Loc 4 900000 Loc 8 800000 Loc 11 700000 Loc 6 600000 Scenario 2- If I select Profit , the Grid should reorder and should display only TOP 5 Locations based on the profit. Profit Loc 8 100000 Loc 3 90000 Loc 6 80000 Loc 1 70000 Loc 11 60000 Thanks, Arnab
。。。View more