6 Replies Latest reply: Sep 23, 2013 8:55 AM by Ali Hijazi

Sum greater than 800 in pivot table

I have a following fields

RNo.   Month year   Quantity

I want to count only those RNo.'s in Pivot table who's sum greater than 800. I cannot apply dimension limits in Pivot Table

Any Idea how to achieve it?

thanks

Lavi

• Re: Sum greater than 800 in pivot table

Hi,

Try like this

=Sum(If(Sum(Quantity) > 800, 1))

Hope this helps you.

Regards,

Jagan.

• Re: Sum greater than 800 in pivot table

Hi

check this condition

use this condition in expression tab

if(sum(amount)>800,count(Rno))

• Re: Sum greater than 800 in pivot table

Hi arya,

thanks but  it didn't worked perfectly in pivot table

• Re: Sum greater than 800 in pivot table

As Arya is saying but check maybe you have to add an aggr to the sum(Amount) what is the dimension that you are using on your pivot table?

• Re: Sum greater than 800 in pivot table

Hi

You probably need something like this:

Sum(Aggr(If(Sum(Quantity) > 800, 1), <dim1>, <dim2>, ...))

Where <dim1>, <dim2>, .... represent all the dimensions of your pivot table. The dimensions must be fields, not calculated dimensions.

Regards

Jonathan