-
1. Re: Filtering for Top ten and Grand Totals
Jennifer VonHagel Sep 7, 2017 3:18 PM (in response to Elizabeth E)1 of 1 people found this helpfulHi Elizabeth, one option is to hide the rows you don't want to show.
In this example, I have a Set that is Top 10 Customers by Profit. I've put in Subtotals so we can see how things play out. With a Set, we can have the Set field give us an indicator of which Customers are In or Out of the Top 10 Set.
I'm going to right click on Out, then choose Hide.
Now you can see the Subtotal and the Grand Total remain intact.
You don't have to have an In/Out field, you could select multiple Name rows using Shift+Select, right-click, and Hide.
If you want the In/Out field to easily hide the Out's, but don't want to show the In/Out column, we can then hide this whole column:
Right-click on the In-Out Column, un-check Show Header
And we're left with the basic table.
Hope this helps,
Jennifer
-
2. Re: Filtering for Top ten and Grand Totals
Elizabeth E Sep 7, 2017 3:50 PM (in response to Jennifer VonHagel)Creating a set is a great idea. That way the top 10 can be dynamic depending on time frame, etc. I can hide the "out" of the set as I don't care to see them and then display the subtotal for the "in" the set. Perfect!
Thanks very much!
-
3. Re: Filtering for Top ten and Grand Totals
Elizabeth E Sep 12, 2017 10:46 AM (in response to Jennifer VonHagel)Hi again,
I just noticed that my 'In set' isn't actually catching the top 10... its grabbing the top 2-3 or so, and then a handful of others that appear to be random, for a total of 7-8 instead of 10.
To create the set I just right clicked on the "Health System" Dimension, then "Create a set". I then went to the Top tab and clicked "By Field" and left the settings as they were (Top 10 by Paid Sum).
Did I do something wrong in setting up the set? Or is there another reason why the In/Out set is not actually showing the top 10?
Thanks!
-
4. Re: Filtering for Top ten and Grand Totals
Jennifer VonHagel Sep 12, 2017 11:04 AM (in response to Elizabeth E)Hmm, are you filtering by other dimensions? Can you send a sample of your data?
Best
Jennifer
-
5. Re: Filtering for Top ten and Grand Totals
Elizabeth E Sep 12, 2017 11:12 AM (in response to Jennifer VonHagel)Yes I am also filtering by time period (current or prior), by county, and by service type (medical, dental, pharmacy, etc.)
Sorry I can't share the data because it has protected medical information. Unless there is a way to share without sharing the underlying data as well....?
-
6. Re: Filtering for Top ten and Grand Totals
Jennifer VonHagel Sep 12, 2017 11:14 AM (in response to Elizabeth E)1 of 1 people found this helpfulCan you mock up how your view is set up using Superstore? They have State and Category that you could use as dimensions...
-
7. Re: Filtering for Top ten and Grand Totals
Shinichiro MurakamiSep 12, 2017 11:17 AM (in response to Elizabeth E)
1 of 1 people found this helpful -
8. Re: Filtering for Top ten and Grand Totals
Elizabeth E Sep 12, 2017 11:20 AM (in response to Jennifer VonHagel)I didn't know about superstore. I'll check that out. Thanks!
-
9. Re: Filtering for Top ten and Grand Totals
Shinichiro MurakamiSep 12, 2017 11:21 AM (in response to Elizabeth E)
-
10. Re: Filtering for Top ten and Grand Totals
Elizabeth E Sep 12, 2017 11:22 AM (in response to Shinichiro Murakami)Thanks, that seems to have fixed it! Strange... what does adding it to context mean? Also, will any of my filters that are dynamic (from a parameter) be affected? It all appears to be working still, so I think its good!
-
11. Re: Filtering for Top ten and Grand Totals
Andrew Kim Sep 12, 2017 11:23 AM (in response to Elizabeth E)In addition to adding the filters to context you could try to filter on the rank: INDEX().
So sort your dimension in the view on Paid, then drag INDEX() to the filter and filter on 1-10.
That would preserve the contents outside of the top 10.
-
12. Re: Filtering for Top ten and Grand Totals
Shinichiro MurakamiSep 12, 2017 11:26 AM (in response to Elizabeth E)
Elizabeth,
Unfortunately, It's difficult to say without seeing data.
One example, but there are a lots. Context Filters in Tableau
I could not find the official helps though.
Thanks,
Shin
-
13. Re: Filtering for Top ten and Grand Totals
Jennifer VonHagel Sep 12, 2017 2:05 PM (in response to Shinichiro Murakami)Thanks, Shin, your answer was much quicker than what I would have done with sample data .
Elizabeth, here are a couple article I like about context filters:
Improve View Performance with Context Filters
Filters and Level of Detail Expressions
Best,
Jennifer