Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a meeting type code is below...
1X1 |
GRP |
3X1 |
2X1 |
CCL |
Lunch |
Dinner |
In that data lot of duplicates is there
How to remove the duplicate in a Meeting type code.
Thanks
Hi Anil...
I am trying Calculated Dimension but i need a count of meetings.
Why dont u tried from expression?
Anyway, try this
If(Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name]), [Client name])
expression it showing wrong...
Will you able to provide sample application?
what is your expected result?