topic Re: Partial Sums in Pivot Table in QlikView

Partial Sums in Pivot Table

Anonymous — Thu, 07 Jan 2016 05:38:41 GMT

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 — Thu, 07 Jan 2016 05:54:42 GMT

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 — Thu, 07 Jan 2016 05:58:40 GMT

Try like:

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

jonathandienst — Thu, 07 Jan 2016 05:58:56 GMT

Use this calculated dimension:

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