Qlik Pivot Table - Yearly Sum column

[mkb_Qlik]

Hello,

I have table like below,

I wish to introduce a new column which shows yearly sum.

e.g  First Column 2019 which is sum of particular 2019 year data & Second column 2020 which is sum of particular 2020 year data

Followed by current monthly breakdown.

How to achieve this , Kindly suggest.

Thanks in advance!

[Ksrinivasan · Accepted solution]

hi,

Sum({$<Period = {"*2019*"}>}Sales),

or 

add one more table resident with Year,

then add into period with value in Master table 

then it will display as you expected,

[mkb_Qlik]

Thanks @Ksrinivasan , For your reply.

However i have completed this request with creating Data island with relevant Measure names and Handled the scenario in Measure with If condition. PFB.

Thank you very much for your assitance!