Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Below expression i declared in variable
sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)+(RangeSum(sum({<Month={$(=max(Month))},BA={'XXX'}>}Values))
+sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)
Its working fine for month selection, Year selection n Quarter selection.
But now i got new requirement that i have to show MTD of that variable.
I mean suppose my above expression giving values like
Apr= 200, May= 300, June= 400, July= 100
When i am selecting multiple selections also i am getting correct values means
Apr&May my result is correct= 500,
but my requirement is if selected May i want to show Apr+May instead of selecting both.
Thanks in advance.