Count of Growth Label

[zain16nib]

Hi,

i need to create a Report 2, format which is given in attached excel file.

kindly guide,

application and data file has been attached.

Thanks in advance,

Regards,

Zain.

[zain16nib]

i want to do this in dashboard not in script, i know this script level.

Thanks,

Zain.

[zain16nib]

waiting for reply

[Anil_Babu_Samineni]

How below are calculated?

0-50	2
above 50	3

Update - My Bad, Why you want only Front End??

[sunny_talwar]

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)