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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s