4 Replies Latest reply on Jan 22, 2015 8:49 PM by Tableau kumar

# Filter to show industries representing 95% of total output

Dear all,

Seems like this should be straightforward to find a solution to, but I have so far had no luck.

To find material industries, I am looking to create a filter that shows all industries that together represent 95% of total output. Think 80/20 rule analysis.

I have tried to create a calculated field to show output % of total and then filter by that, but have had no luck since [output]/sum([output]) is not accepted. How would you create a percentage of total field?

Thank you for your help.

All the best,

Chris

• ###### 1. Re: Filter to show industries representing 95% of total output

Hi we can use the parameter to change the %.

if [Select % of Spend]=.95 then "show" end

• ###### 2. Re: Filter to show industries representing 95% of total output

Hi,

We can get it either Top 95% of total, ot Bottom 95% of total by using Sort option.

Top Cities upto 95% of total Sales

Bottom Cities upto 95% or Less

I used t he Following calculations for this task,

Running Sum (Field)

Syntax: RUNNING_SUM(sum([Sales] ))

Window Sum (Field)

window_sum(sum([Sales] ))

Upto .95  (Field)

Syntax:

if (RUNNING_SUM(sum([Sales] ))/ window_sum(sum([Sales] )))<=.95 then (RUNNING_SUM(sum([Sales] ))/ window_sum(sum([Sales] ))) end

1 of 1 people found this helpful
• ###### 3. Re: Filter to show industries representing 95% of total output

Some additional Information to previous Post.

If you want to show list of cities upto 95 % of total, & hide remaining things, then create a calculated field (Boolean) then drop it into Filters then select "Yes". like the below screen shot.

Name: Show Cities upto 95 % of  Running total

Syntax: (RUNNING_SUM(sum([Sales] ))/ window_sum(sum([Sales] )))<=.95

Best Regards

Laxman Kumar

• ###### 4. Re: Filter to show industries representing 95% of total output

Hi Christian,

Are above posts giving your expected results OR do you need some extra help from our forum?

Best Regards

Laxman Kumar