Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Percentage Calculation

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

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

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • Ritaf1983's avatar
        Ritaf1983
        Super User
        2 years ago

        Where ?
        Nothing changed in the attached link:

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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