Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello , i have to show YOY change in percentage
sample data i got is
Group Year value
AD 2014 17713
AD 2015 15012
AD 2016 13875
MF 2014 82742
AD 2015 81375
AD 2016 95777
currently what i am showing in a line chart
Dimension:1)Year
2)Group
Expression:sum(value)
what i want to show is YOY of each year
i mean
on top line chart
81375-82742 in percentage
95777-81375 in percentage
on bottom
15012-17713 in percentage
13875-15012 in percentage
So how to show those diff plz
thanks
naveen
Haven't tested but may be something like this
Aggr(IF(RowNo()=1,0,(SUM(value)/Above(SUM(value)))-1),Group,Year)
Untick Suppress Zero Values from Presentation tab.