Partial Sums in Pivot Table

[Anonymous]

Hi

I am using the following Pivot table in my dashboard,

The user wants to see Total only if there is more than one Purchase Order coming under a customer.

In the above example I want to show Total only for the Customer 'Smith' and not 'Greyson'.

Is there a way to do so?

Thanks

[tamilarasu]

Hi Koushik,

Try,

If(Dimensionality()=1 and Customer='Smith', Sum(Sales),

If(Dimensionality()<>1, Sum(Sales)))

Edit:

Sorry. I didn't read your question fully, Check the below expression

If(Dimensionality()=1 and Count(Order_Type)>1, Sum(Sales),

If(Dimensionality()<>1, Sum(Sales)))

[tresB · Accepted solution]

Try like:

If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))

[jonathandienst]

Use this calculated dimension:

Aggr(If(Count([Purchase Order]) > 1, Customer), Customer)