hi,
i have a pie chart -
the dimansion is expression-
=if(aggr(((sum(MONTHLY_RCVD_UNITS_QTY_NEW)-sum(MONTHLY_RJCT_MRB_SI))/sum(MONTHLY_RCVD_UNITS_QTY_NEW)),Central_BP)>=0.95,'Preferred',
if(aggr(((sum(MONTHLY_RCVD_UNITS_QTY_NEW)-sum(MONTHLY_RJCT_MRB_SI))/sum(MONTHLY_RCVD_UNITS_QTY_NEW)),Central_BP)>=0.85,'Satisfactory','Unsatisfactory'))
the expression-
count(distinct bp_code)
i want that each value of my dimension will hava a color anf if im choosing ine value the color will stay
i try to do it with presistent color ant its not work
how can i do it?
tnx,
adi
