LucaMartini1969

Comments

I tried the suggested solutiion, adding the ELSE 1, but unfortunately the SM% is not working, it is still showing same %. The is is whith PARTTION BY, do you know some way to fix PARTITION BY issue?

in Partition By not working to show correct SM% when I change parameters view options Comment by LucaMartini1969 May 2023
Hi ST Superman, so if I understood correctly as first option you are suggesting to modify my formula like below where "Geo/Prod view 1" is: Case when Geography/Product View = 'Geography' then P&L Account name when Geography/Product View = 'Product' then P&L Account name when Geography/Product View = 'P&L' then P&L Account…

in Partition By not working to show correct SM% when I change parameters view options Comment by LucaMartini1969 May 2023