Need Help..

[paulwalker]

Hi All,

I have one pivot table,

Dimensions :  ID, Month and Status

Measure:  Count(Status)

I want show only Count(ID) greater than 2, i have duplicate ID's depends on status....

I am using in Dimension if(Count(ID)>2, ID)

But, it showing error.. any thing wrong here....

[Chanty4u]

hi

Please try this once

if(count(distinct(id)>2,id)

Thank you

Suresh

[paulwalker · Accepted solution]

Yeah, I got it..

I have used this expression...

=if(Aggr(Count(ID),ID)>1,ID)

[Chanty4u]

good

[timanshu]

Hi,

Kindly mark question as answered