Re: Count of Growth Label

Try this

Dimension

=Aggr(
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<0,'Negative',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)=0,'Zero',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>0 and (((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<=50,'0-50',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>50,'above 50'))))
, br)

Expression

=Count(DISTINCT br)

Capture.PNG