I created a calculated field as below. Please, find the attached workbook as a reference. You should change the table calculation's "compute using" dimension.
Please let me know if this helped.
Rolling sum_mia.twbx 44.2 KB
Remove the month field from columns and create a caluclated field with
if DATEname('month', [kxfhcg])='May' then '90 Days'
ELSEIF DATEname('month', [kxfhcg])='June' then '60 Days'
ELSEIF DATEname('month', [kxfhcg])='July' then '30 Days'
and drag it on to columns
I am not able to view the workbook.Could you please resend the workbook.
Workbook opens OK. It's version 9.3. If you have an older version, it won't open for you.
But everything you need to reproduce what Mia did is visible in the screenshot in the reply.
Thank you guys
I could do...Wish i could think in that sense