Quickie on combining index and sub totals

In case you encounter the problem that you want to number your table by using index and still add a subtotal and thereby run into this here is the workaround: Copy your dimension which you intent to number using the index. In the above example, it is customer name. Put the original customer name to … Continue reading Quickie on combining index and sub totals

Another quickie on aliasing

Have you ever encountered that you were creating BANs (Big (Buttocks) Numbers) and wanted to show sub-segments as well as the total side by side all in one sheet? Let's do an example: Connect to superstore sample data and but segment on columns. Sales goes on Text. Add "Totals" from the Analytics pane This is … Continue reading Another quickie on aliasing

A quickie on renaming and aliases

In many cases your data source will provide you with rather technical column names, be it dimension or measures. Or, you are usually fine with the naming but for a specific table or chart you just need that slightly changed name label to make it even clearer for your audience. Now what usually you would … Continue reading A quickie on renaming and aliases

A quickie on Filters, actions and tooltips

Almost certainly during the course of work with Tableau one will encounter the issue of trying to implement a tooltip and at the same time using a dashboard action or a quick filter that shall also filter the tooltip. Starting with the action filters Unfortunately, we cannot pass through the action as a filter to … Continue reading A quickie on Filters, actions and tooltips

Quickie: Show totals only for one column in a text table but keep all details in the other columns

For today I got a tip which mostly is layout'ish but also somewhat data privacy related The question was how we could get a table like this: to only show Details for in this example the sales but profits should only be shown in the (Sub) Total line. Building on Jeff Shaffer's great blog post … Continue reading Quickie: Show totals only for one column in a text table but keep all details in the other columns