Hi,
I have a pivot table with Weeks in Columns. I want to get two weeks before data matching with different column (Version Date).
Week_Start is column in pivot table and it is date integer.
Measure in Pivot Table:
SUM({<Version_Date = {"$(=Date(Week_Start -14,'DD-MMM-YY'))"}>}Value).
Above expression is working fine if I select one Week_Start but it should work with out any week filter. I am not able to create mock up data, I tried to capture the requirement in below screenshot.
Regards,
Sai Krishna.