Hi Vivek Yadav – For many date ranges for reporting I find myself leveraging an existing SubVar i.e. CurrPr and developing the report based off of this CurrPr, CurrPr -1, CurrPr -2, CurrPr -3, CurrPr -4. In this case, if CurrPr is set to May, -1 = Apr, -2 = Mar, -3 = Feb, -4 = Jan.
Communicate with Data 
How can we use Range Function as decrements order for example (May Apr Mar Feb Jan)
LikeLike
Hi Vivek Yadav – For many date ranges for reporting I find myself leveraging an existing SubVar i.e. CurrPr and developing the report based off of this CurrPr, CurrPr -1, CurrPr -2, CurrPr -3, CurrPr -4. In this case, if CurrPr is set to May, -1 = Apr, -2 = Mar, -3 = Feb, -4 = Jan.
LikeLike
Thanks for your reply but i have to use minimum number of columns , how can i create optimal report
LikeLike