Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
sorry, choose the text color white.
hi using try .
if (Dimensionality() = 0,
sum( total Belgium) + sum(total Netherland))
regards
GERNAN
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.
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