Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data like below and my requirement is
I have filter year and month if I select year 2016 and month aprl
my result should be. 2015 all available sum and in 2016 jan+feb+mar+aprl
so previous year sum as one column 2016 jan-aprl sum in one column
what if you select 2015 or 2014?
Hi,
user want to select atleast one year once only.
Create Flags for Previous year and add that Flag in your first condition.
For current year add the data until current month.
Will you be able to share the expression you're using?
Create a master calendar and add some flags in there for YTD / LYTD etc
Fro example:
,YearToDate(Date)*-1 as CurYTDFlag
,YearToDate(Date,-1)*-1 as PriorYTDFlag
,InYear(Date,now(),0)*-1 as CurYearFlag
,InYear(Date,now(),-1)*-1 as PriorYearFlag
Then just use those flags in set analysis.