I have a demo database of 'Sales' like this
So I need to calculate categories contribute growth rate, for example, when I filter 2021, each category it will be (SUM (category sales of 2021) - SUM (category sales of 2020))/SUM (TOTAL sales of 2020)
1 answer
I would use lod expressions to get the get category totals like - based on the image
2020sales = {fixed category,year : sum(if year=2020 then sales end)}
and so on
give it a try and return here and post your workbook if there are questions
Jim
