1 of 1 people found this helpful
There is a table calculation that will create your rolling 6 month totals - Just apply it to the sale, quantity. and profit
If you prefer to use a formula the formula is
Then your ratio is
The result is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you so much for the reply.
In the above post i have mention the values in the text to understand expected result.
But i need to display only the ratio on bar Graph. I understood that you have used table windows calculations but that wil not work with bar char.
for recent 6 months i need to show for every month rolling 6 moths data how i explained in the first post.
Do you have solution for this?