Thanks for sharing the workbook but the percentage is not changing with the total number. Can you help me change the percentage as well?
They do change.
When selecting the States on the dashboard,
the percentages are changing on the both views
(the Number of orders and the Number of Sales).
Thank you for pointing that out. Yes, it works wonderfully when i click on states & top purchased products. The total number and their respective percentages are dynamic.
However, when i use the profit, sales and discount filters on the top right-hand side, the percentage becomes static and only the total number changes. How can I make the percentages dynamic even when i use those filters?
Thank you, again.
1 of 1 people found this helpful
OK, if you want to have the (static) Grand Totals
(for the whole dataset) as the Denominator(s) --
so changing the Range Filters would change
the respective Percentages -- then you'd like
to remove those Range Filters out of Context.
Make them the normal dimension filters back again --
as you'd got them in your original workbook.
I beg your pardon for changing things first
without asking you about the outcome.