how to show growth percentage year on year in line chart ?

[#1]

Hi Friends,

Please find the attached QVW. How to show growth or decrements on year year  segment wise.

So I need to show Segment A variation by year wise ,Segment B  and Segment C. Please do modifications in line chart.

[sunny_talwar]

You want to see YoY growth just for Segment A or all Segments on the line chart?

[sunny_talwar]

Is this what you want?

Expression for Growth:

Sum(sales)/Above(TOTAL Sum(sales), Count(TOTAL <Year> segment))-1

Also attaching the your application for reference.

Best,

Sunny

[#4]

Hi Sunindia,

Thanks for your help. I need growth for all segments. I have tried this expression in scenario. I am getting error i.e., NO DATA TO DISPLAY.

[sunny_talwar]

Well I guess I would need to see your scenario to give you a better solution for your scenario, because the sample your prepared seems to work with expression I gave you, isn't it? Can you share a reduced version of your application or may be a more representative sample of your actual scenario to help you better?

Best,

Sunny

[#6]

Hi ,

Please find the below link..

how to show growth percentage year on year in line chart