Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help me , I need to count the no of states falling under each class
I have used below expression in list box to get Pareto Class (A,B,C)
=Aggr(
If(Rangesum(Above(Sum({1} SalesNetValue)/Sum({1} total SalesNetValue),1,RowNo()))<0.8, 'A',
If(Rangesum(Above(Sum({1} SalesNetValue)/Sum({1} total SalesNetValue),1,RowNo()))<0.9, 'B',
'C')),
(StateCode,(=Sum({1} SalesNetValue),Desc))
)
As said in the other thread, use the aggr() function in a calculated dimension (e.g. in a straight table chart or bar chart) and use as expression
=Count(DISTINCT StateCode)
[you can also use your list box and add the Count() to the list box expressions, this would be pretty similar to the straight table version, but with the coloring of the list box dimensions]