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?
Try like this
=Sum(If(Sum(Quantity) > 800, 1))
Hope this helps you.
check this condition
use this condition in expression tab
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?
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.
Retrieving data ...