2 Replies Latest reply on Dec 3, 2012 12:48 AM by herbert jiri

Set to calculate against the total and not the Top N Clients only

herbert jiri Nov 30, 2012 2:25 AM

Hello I created a set with a parameter of Top N Clients in Tableau 7 and I am Iooking for a formula that if I select the top 10 clients and want to show the percentage of the total, it must give me the percentage against the total client population and not only for the top 10. I know this is one of the new built in functions in Tableau 8 but we would like to do it for our clients in Tableau 7 so long. Your help guys will be much appreciated.

1. Re: Set to calculate against the total and not the Top N Clients only

Tracy Rodgers Nov 30, 2012 1:42 PM (in response to herbert jiri)

Hi Herbert,

This can be done by creating a calculated field using the parameter similar to the following:

if index()<=[Top N Parameter] then 'show' else 'hide' end

Then, place this calculation on the view. Right click on the 'hide' member and select Hide. Finally, do the percent of total calculation--this will include all of the values because the values have been hidden not filtered out.

Hope this helps!

-Tracy
Like Show 0 Likes(0)

Actions
2. Re: Set to calculate against the total and not the Top N Clients only

herbert jiri Dec 3, 2012 12:48 AM (in response to Tracy Rodgers)

Thanks so much Tracy that really worked out perfectly.

Herbert
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Set to calculate against the total and not the Top N Clients only

1. Re: Set to calculate against the total and not the Top N Clients only

2. Re: Set to calculate against the total and not the Top N Clients only

Actions

More Like This