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 bar chart labelling

For today I have a quick tip on creating a specific labelling for bar charts. This has come out of Workout Wednesday 2021 Week 44. Usually, labels are either at the end of the bar chart (automatic / right), at the end but inside the bar (left) or inside centered (center alignment). But what if … Continue reading A Quickie on bar chart labelling