I used the samplestore data to replicate your table.
First made the following calcs:
Bring your reference date to Months on in Columns.
Bring Measure Values to Text.
Then Measure Names to Rows.
To get the Row Grand totals go to: Analysis > Totals > Show Row Grand Totals
Hope this helps
Superstore 2.twbx 356.4 KB
i replicated the same formula and it worked perfectly for me. Thank you for all your help. Highly appreciated
Awesome, glad to help