Showing total of only subtotals

[#1]

Hi,

I'm busy with a pivot table.
Now I can easily showing the subtotals of rows.
But now I want to make a total of these totals, how is this possible?

Example:

Prod                         Belgium          Netherlands           Total        

ProductA                         5                    5

ProductB                         5                    6

ProductC                         6                    2

Total                               16                   13                    29                   

Regards

[sridhar240784]

I'm not sure, I have understood your question

Properly.

to identify the difference between total and subtotal

You may use dimensionality() and secondarydimensionality()

Functions

You may play around with these functions.

Hope this helps you.

-Sridhar

Message was edited by: Sridhar Ethiraj

[udit_kumar_sana]

Hi,

Please find here the attached file for the solution.

By this you will get total in all the rows of last column.

In order to show total at last row only.

-go in view option ,select  design grid.

-place the cursor over last column data and right click choose custom format cell option ,there choose text color weight.

-this will give you just total in last column.

-to remove background grid deselect from view ,the design grid option.

Regards,

Udit

[udit_kumar_sana]

sorry, choose the text color white.

[#5]

hi using try .

if (Dimensionality() = 0,

sum( total Belgium) + sum(total Netherland))

regards

GERNAN

[#6]

I don't really understand you.

Should I make a new expression => Total with following statement:

if (Dimensionality() = 0,

sum(MISTotaal)

When I use this expressions, it gives me after every "country" a blank line.

[#7]

this is my example . i think it helps for you

Belgium as Bel

Netherlands as Neth

i use expression in the TOTAL is

if (Dimensionality() = 0,

sum( total Bel) + sum(total Neth))

GERNAN