5 Replies Latest reply on Dec 31, 2018 2:35 AM by Yuriy Fal

# How to create a dynamic percentage of total?

Hello,

I am using the superstore data to replicate the issue i am facing. I want to create a dynamic percentage of total which changes with filter.

I have attached a packaged workbook which help me show you my exact pain point. The dashboard shows the sales, profit, discount and products purchased by country. To make the analysis more meaningful, i have also put in total number of orders and sales on a separate sheet and put it on the dashboard to help the user get a quick grasp of what is happening.

When i use filter, the total number changes. However, i want to also see the 'percentage of total' for the total number of orders and sales. Just like the total number is impacted when a filter is applied, the percentage of total should also be impacted.

I tried using quick calculation - 'percentage of total' and the number comes to 100%. But it doesn't change along with the total number when the filter is applied.

Can someone help me with this?

Thank you.

• ###### 1. Re: How to create a dynamic percentage of total?

Hi Richa,

The FIXED LOD expression (in the Denominator) could help.

Don't forget about the Context Filters, though.

Yours,

Yuri

• ###### 2. Re: How to create a dynamic percentage of total?

Hi Yuriy,

Thanks for sharing the workbook but the percentage is not changing with the total number. Can you help me change the percentage as well?

Cheers,

Richa.

• ###### 3. Re: How to create a dynamic percentage of total?

Hi Richa,

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).

Yours,

Yuri

• ###### 4. Re: How to create a dynamic percentage of total?

Hi Yuriy,

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.

Best,

Richa.

• ###### 5. Re: How to create a dynamic percentage of total?

Hi Richa,

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