
Re: Issue with pivot table Dimensionality() calculation
anbu cheliyan Apr 10, 2015 4:51 AM (in response to Vishnu Sreekumar )Try this expr
=Sum(If(Aggr(Sum(Count),Category,Item) >2,Count))

Re: Issue with pivot table Dimensionality() calculation
wrvs fsbv Apr 10, 2015 5:04 AM (in response to Vishnu Sreekumar )Use this instead :
if(Dimensionality()=1,sum(if(Count>2,(Count),0)),if(Sum(Count)>2,Sum(Count),0))

Re: Issue with pivot table Dimensionality() calculation
Ankita Agarwal Apr 10, 2015 5:17 AM (in response to Vishnu Sreekumar )Hi Vishnu,
Write the expression as :
=sum(if(Count>2,Count,0))
Find your attached application with correction
Thanks and Regards,
Ankita

Sample (1)PivotTable.qvw 155.2 K


Re: Issue with pivot table Dimensionality() calculation
Jonathan Dienst Apr 10, 2015 5:39 AM (in response to Vishnu Sreekumar )You need an Aggr() to get the correct sum of rows value in a pivot. It will look like this:
Sum(Aggr(if(Sum(Count)>2, Sum(Count), 0), Category, Item))
HTH
Jonathan

Re: Issue with pivot table Dimensionality() calculation
Shiva Reddy Apr 10, 2015 5:50 AM (in response to Vishnu Sreekumar )tested,it's working
=Sum(If(Aggr(Sum(Count),Category,Item)>2,Count))

Re: Issue with pivot table Dimensionality() calculation
Saritha Xavier Apr 10, 2015 6:37 AM (in response to Vishnu Sreekumar )Hi Vishnu,
Please try this expr,
sum(if(Count>2,
Count,
0))
Saritha Xavier

Re: Issue with pivot table Dimensionality() calculation
Alexandra Chizhova Apr 10, 2015 6:59 AM (in response to Vishnu Sreekumar )hi.
if() helped! try using this in you expression
sum(
if(count > 2,
count,
!0)
)

Re: Issue with pivot table Dimensionality() calculation
Vishnu Sreekumar Apr 10, 2015 7:34 PM (in response to Vishnu Sreekumar )Thanks all.
Actually all of the answers worked. But for my actual scenario, I found
Sum(Aggr(if(Sum(Count)>2, Sum(Count), 0), Category, Item)) as the best fit.