Suppose you have a table with product name, product quantity, product unit sales price, and months. How can I show the change in total prices per month? For example:
Hi @mehmetalikarabulut ,
You can use a summarize tool to find your total sales per month. Then with a multi-row formula tool, you can create what will give you the % change
That is :
100 * (Current Month Sales-Previous Month Sales) / Previous Months Sales
So your change is 106 % not 206%. To get 206% your expression should be
100* Current Months Sales / Previous Months Sales
Hope that helps,
Angelos
Thanks a lot. Its work.