In the example below I want to show only Total volume Stage movement at the end and not the subtotals in the columns.
In my view, I have drill down Region->Category->subcategory by. The key was to work out which row was the Grand Total row there are a few ways of doing this but I like using the formula: MIN(CATEGORY) <> MAX(CATEGORY) This is a neat trick because this expression is only ever False when the Category is in the Grand Total (NB if the Grand Total is only made up of one item you start running into. Hi Guys, I need help.I am building a Pivot table and I need to show ONLY the Grand totals at the end of the table.In this case, we have two hierarchical filters, it would be best if we keep the upper level filter (Country) as from ‘All Values in Database’. I have a requirement where I want to show Grand total at the category level only. The show ‘Only Relevant Values’ option only works well when we would want to filter down the categories.
Step 1: Create a calculated field Click Analysis > Create Calculated Field. Environment Tableau Desktop Answer This example uses the Superstore sample data source and can be reviewed in the attached workbook.
#HOW TO SHOW ONLY GRANDTOTAL IN TABLAUX HOW TO#
Now if I want to pick ‘Wales’ from Country, I’ll have to select ‘All’ from Subject. How to assign a different color for Grand Total only. If I set show ‘Only Relevant Values’ for both Category (Country in this case) and Sub category (Subject), once I filter Country, Subject reduces as shown before, however, if I filter Subject, Country reduces as well. Thanks Andy for pointing out the potential problem with this function. Now the list becomes much shorter with all values relevant to the selected university. The Subject filter has a very long list, the users could get confused if they were to click on one of those courses which isn’t offered by the selected university, since the view would just disappear.Ĭlick on the dropdown menu next to the Subject filter, switch the option from ‘All Values in Database’ to ‘Only Relevant Values’.
(data point) are not displayed anymore, only the grand total for each Product. We were working on National Student Survey data last week, most of us had filters for ‘University Group’, ‘University Name’, and ‘Subject’. This article shows you how to show or hide data points representing total.