A crosstab with rolling sum

[Anonymous]

Can someone please help me in creating a crosstab table where I can show rolling sums.

Below is how I want to show the corsstab in power BI visual  and the table structure that I have.

I am trying to find a way to show 'Rolling 3 month Sales' I am flexible with the table structure and can change it if that makes the calculation easy.

[SpartaBI · Accepted solution]

@Anonymous attached a file with how to solve this.
CrossTab With Rolling Sum.pbix

      

Showcase Report – Contoso By SpartaBI