Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How are these fields working? Year =,Month=,Week=,DateField=,
I found it is used to ignore the selection, but for me, I am able to select from these fields.
Please explain how these fields are working.
They will be applied to the Sum(Sales) aggregation, but not to the others, so you would need to apply these at each aggregation to be ignored by all. See example below ..
Sum(
{<Year=, Month=, Quarter=, DateField=, DateNum={">=$(=Num(YearStart(Max({<Year=, Month=, Quarter=, DateField=>}DateNum))))<=$(=Max({<Year=, Month=, Quarter=, DateField=>}DateNum))"}>}
Sales)
or create a variable for this combination of fields and use that
eg vDates Year=, Month=, Quarter, Week, DateField=
and change your expression to
Sum(
{<$(vDates), DateNum={">=$(=Num(YearStart(Max({<$(vDates)>}DateNum))))<=$(=Max({<$(vDates)>}DateNum))"}>}
Sales)