Pivot table totals

[fallenangel6]

hi all,

i want pivot table total for all measures except a measure which has text in it.  below column is present in my table and i dont want any total for this measure.

[dapostolopoylos]

Why don't you move this column to the dimension part of your chart?
It is not a measure, why bother find ways to supress totals for this column?

[sunny_talwar]

May be do this

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

[fallenangel6]

this is displayed using the difference of two measures ie sum(grn qty)-sum(po qty).

[fallenangel6]

it doesnt work. this is my expression.

If(Sum(INVOICE_QUANTITY)=0,'No Invoice',
If(Sum(INVOICE_QUANTITY)<Sum(GRN_QUANTITY),'Partial Invoice',
If(Sum(INVOICE_QUANTITY)=Sum(GRN_QUANTITY),'Full Invoice',
If(Sum(INVOICE_QUANTITY)>Sum(GRN_QUANTITY),'Higher Invoice'))))