Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
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,
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!