Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try like this
=Sum(If(Sum(Quantity) > 800, 1))
Hope this helps you.
Regards,
Jagan.
Hi
check this condition
use this condition in expression tab
if(sum(amount)>800,count(Rno))
Hi arya,
thanks but it didn't worked perfectly 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?
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