How do I do add both the rows and the columns?

[josephinetedesc]

How to group column names as a new dimension?

Hi all

This is a continuation of the question that I asked here - but it might have nothing to do with it.

I want to do something like this:

I can get the sum of the columns but I cannot get the sum of the rows.

Also where should I look for something that will show me how to do an expansion of a table - but one step at a time.  For for example

All Months - then

all div_name_short then

Drums, flue, Guitar

Thank you

Jo

[Anil_Babu_Samineni]

Try this way?

Pivot Table SubTotals when a Dimension determines Expression Calculation

[josephinetedesc]

Thank you - I have now learnt about dimenionality!

I wonder if  you could use it as a selection - i you choose dimensionality 1 the the total would show dimension 1 etc. ...  I will experiment tomorrow

Thank you

Jo