Sum greater than 800 in pivot table

[harleen_singh]

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

[jagan]

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

[#3]

Hi

check this condition

use this condition in expression tab

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

[harleen_singh]

Hi arya,

               thanks but  it didn't worked perfectly in pivot table

[ali_hijazi]

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?

[jonathandienst · Accepted solution]

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