Change in Total Price Per Month

[mehmetalikarabulut]

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:

[AngelosPachis]

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

[mehmetalikarabulut]

Thanks a lot. Its work.