Pivot Table - Requirement

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Pivot Table - Requirement

Gysbert_Wassenaar — Mon, 04 Apr 2016 13:25:37 GMT