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 the front and insert your copy behind the index. Right click original customer name and deselect “show header”.

Edit your index calculation as shown in this screenshot:

And that is it already, as you can see on the screen we got the numbering and the subtotals combined.

That’s my quickie for today.

As always appreciate your feeback.

Until next time.

Steffen