Percentage Calculation

[Anonymous]

Hello Everyone,

I need to calculate the percentage change (increase or decrease) over the year for various codes, taking into account that there can be different suppliers for the same code. Additionally, I want to create a line chart displaying the percentage change, with separate lines for each supplier if there are two suppliers.

follow the link.

https://docs.google.com/spreadsheets/d/1KdJng3_lmeIZP69Ppz3EDm4S1Yn3mQZi/edit?usp=drive_link&ouid=11... 

Thanks in advance.

[Anonymous]

Hi @Anonymous 

Thank you very much Ritaf1983 for your prompt reply.

If your problem has been solved, please accept it as a solution!

Regards,

Nono Chen

[Ritaf1983]

Hi @Anonymous 
Can you show the desired result?

[Anonymous]

Hi Rita,
You can check the expected result now.
Thanks,
Regards,
Rohit Terkar

[Ritaf1983]

Where ?
Nothing changed in the attached link:

[Anonymous · Accepted solution]

Hi Rita,
I have managed to get the result.
Thank you!