Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

add condition in set analysis?

I have the following expression for top 10 Customers

count({<[Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])

I want to add the following two condition in expression

1) Customer_type=Customer

2) WildMatch(GROUP,'*operations*')=1

Thanks in advance.

2 Replies
Gysbert_Wassenaar

Perhaps this does what you want:

count({<[Customer_type]={'Customer'},GROUP={'*operations*'} [Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])


talk is cheap, supply exceeds demand
sunny_talwar

or this:

Count({<[Customer_type]={'Customer'},GROUP={'*operations*'}, [Customer Name]={"=Rank(Count(TOTAL <[Customer Name]> {<[Customer_type]={'Customer'},GROUP={'*operations*'}>} [Ticket No]))<=10"}>} [Ticket No])