Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I'm having an issue in showing the top 20 customers in pivot table.I'm using the below Expression at calculated dimension.
The chart is showing empty.i don't know where i'm going wrong.
=if(aggr(rank(sum(TP_GrossPremium_LC_1)),if(CUST_CATG='02',CUST_NAME))<=20,if(CUST_CATG='02',CUST_NAME))
Regards
Krishna
Hi,
why you have used if statement ?
if it is for excluding something from sum
the it should be like
=if(aggr(rank(sum(if(CUST_CATG='02',TP_GrossPremium_LC_1))),[CUST_NAME)<=20,[CUST_NAME]))
// [CUST_NAME] is your group by column.
if you are looking for something else then clear your requirement.
Thanks
BKC
Hi,
try like
if(CUST_CATG='02',aggr(rank(sum(TP_GrossPremium_LC_1)),CUST_NAME)<=20,CUST_NAME))
Regards
Hi,
why you have used if statement ?
if it is for excluding something from sum
the it should be like
=if(aggr(rank(sum(if(CUST_CATG='02',TP_GrossPremium_LC_1))),[CUST_NAME)<=20,[CUST_NAME]))
// [CUST_NAME] is your group by column.
if you are looking for something else then clear your requirement.
Thanks
BKC