Undesired total in pivot table

[Anonymous]

Hallo,

I'vo got a pivot table with a code in DIMENSION, and quantity, unit cost and unit cost*quantity in EXPRESSION.

For each code, I'd like to obtain the total of quantity and cost*quantity BUT NOT the total of unit cost (because it's senseless, obviously), but the option "Total mode" in not available.

Could someone help me, please?

Thks,

N.

[sunny_talwar]

Pivot table doesn't have a total mode option, but you should be able to replicate what you need using Sum(Aggr(...)) function. In your case you might just need to add Sum() outside cost*quantity if they are field names

Sum(cost*quantity)

or

Sum(Aggr(cost*quantity, <YourChartDimensions>))

[Anonymous]

Thank you for the replay; maybe I didn't explain the problem very well: the pivot table shows the sum of the unit costs (as well as the other two fields) but I don't want it to show.

Thanks.

N.

[sunny_talwar]

May be use Dimensionality() and/or secondaryDimensionality() to hide the totals. Something along these lines:

If(Dimensionality() = 0, Null(), YourExpression)

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()