Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to plot 5 years of Sales growth in a graph for three companies.
Formula uses is -
(Sum(Sales)/Above(TOTAL Sum(Sales))-1)*100
but the above is working for only one Company and not working for three.
I have tried the following also
=(aggr((Sum(Sales)/above(total Sum(Sales))-1)*avg(1),[Company],FY))
The above is showing accurate values for few FY and incorrect values for some years.
Please guide.
@PSCET Could you please provide some sample data set?
Sample data enclosed. I have to plot growth of three companies for there FY in a single chart.
Thanks in advance