Pivot Table - Requirement

[priyarane]

Hi Community,

Is this possible.

I tried to approach like below

Prevous Dimension :

=aggr(only({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB),IRB)

Current Dimension:

=aggr(only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB),IRB)

Expression - Sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}RWA)

Can some suggest me if you come across these kind of requirements (Matrix reports)

I got like below.

[Gysbert_Wassenaar]

Looks a bit like this question: calculate row wise last six months data using chart