I have already tried that but it is not working as expected. Problem is sales value of a particular month is different when you change the selection.
Please let me know if you have anyother suggestion please.
What should be passed in place of field? I my case I am using cyclic group. When I passed in the below formula it didn't work. Please let me know if you have any other solution.
The exact problem is, for example when I select Week as 45 value it is showing % of profit is as 69% and where are when I select Week 45 for the same week it is showing profit as 70%. The report is very complicated. We are trying to do the week on week sale and month on month sale. Hope my problem is understood.