It contains year over year comparison for sale of each customer. i have a straight table that shows 2019, 2020 sales and YoY change and the table shows top 10 customers based on Year over year change. the second set shows total data.
What i want to do is calculate the percentage of top 10 year over year change vs total sales of 2020
Thanks for you reply, but this does not solve my issue. my fault actually as i was not clear earlier.
i have the data for 2019 and 2020 combined. then i use aggr function for splitting them into column by year and then i calculate Year over Year change. Your solution assumes the year data is separated which it is not.