Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))
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)))
Try like:
If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))
Use this calculated dimension:
Aggr(If(Count([Purchase Order]) > 1, Customer), Customer)