Hi,


I am trying to achieve an OLAP cube report in excel using pivot tables.
Following is the scenario:

I have a dimension called part (with values A, B, C, D,etc) and within that
another dimension called Rank. The data is employee counts by gender. The
data is getting displayed properly along with the total counts for various
parts as the sample shown below:

Part A Male Female
Professor 15 20
Assistant professor 30 18
Part A Total 45 38
Part B
Professor 5 3
Assistant professor 0 5
Part B Total 5 8
Part C
Professor 30 0
Assistant professor 10 8
Part C Total 40 8


Now I need Part A+B total row to be displayed after Part B total.

Is there any way to obtain this in the excel?

Thanks in advance

Vinay