7 Replies Latest reply on May 17, 2017 11:50 AM by Karolina Skvortsova

# How can I calculate % of total using filters?

Problem: when I choose the filter, I can't see the real % of total. Instead of that I see 100%.

I tried to use the following formula COUNT([Task Id]) / SUM({EXCLUDE  [Days] : COUNTD([Task Id])}),

but it couldn't helped me(

Please find below some screens that explain my problem

• ###### 1. Re: How can I calculate % of total using filters?

Hi Karolina,

Find my approach as alternative below and stored in attached workbook version 9.3 located in the original thread

Hope it helps.

Regards,

Norbert

1 of 1 people found this helpful
• ###### 2. Re: How can I calculate % of total using filters?

Thank you so much for your great explanation and detailed example. However, I need to demonstrate my data by months (since August 2016), as a result, when I use the following formula in denominator of "% of" I have huge amount. How can I fix the total amount by months?

In the denominator of the field "% of" I use the following formula {fixed:COUNT([Task Date])}

1 of 1 people found this helpful
• ###### 3. Re: How can I calculate % of total using filters?

Hi Karolina

Something like

{fixed Month(Task Date): sum(%of)} should do the trick;)

Regards,

Norbert

1 of 1 people found this helpful
• ###### 4. Re: How can I calculate % of total using filters?

Norbert, thank you so much for your help! I've applied the following formula and unfortunately, it hasn't been worked.

I also get 4767 instead of 165

1 of 1 people found this helpful
• ###### 5. Re: How can I calculate % of total using filters?

Also the problem is related to aggregation as I need to calculate the number of tasks as COUNT([Task Date])

And, as a result, I need to aggregate denominator as SUM({fixed:COUNT([Task Date])})

Can I avoid this problem with aggregation?

• ###### 6. Re: How can I calculate % of total using filters?

Hi Karolina,

Regards,

Norbert

• ###### 7. Re: How can I calculate % of total using filters?

Thank you so much for your great help! Now this formula works: