Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=sum({<[CalendarYear]={"=CalendarYear-1"},[Material Number (Product)]={
'xyz',
}>}Quantity)
it does't work
on simple filter [Material Number (Product)]={'xyz'} is effective
Try this
=sum({<CalendarYear={"$(=Max(CalendarYear)-1)"}, [Material Number
Are you using this measure into kpi or table object?
Try this:
=sum({<[CalendarYear]={"$(=CalendarYear-1)"},[Material Number (Product)]={'xyz'}>}Quantity)
Best Regards,
yes either table or pitvot table
Try this
=sum({<CalendarYear={"$(=Max(CalendarYear)-1)"}, [Material Number
It works! thanks so much. But why so? Is there any document that describes how to execute operation with fields?