Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this set analysis below to work out sum of sales for the past 12 months ( my MonthYear Numberic column is like 202009, 202008 )
=NUM(SUM(
{1<[MonthYear Numeric] = {"<=$(=Max([MonthYear Numeric])) >$(=Max([MonthYear Numeric])-100)"},
>}Sales),'€#,##0')
But this set anlysis is fixed at the moment, when I try to apply filters, this expression wouldn't be affected.
I need to filter this by [Client] and [Product]...
Could someone please help me?
Thanks
Joe
Try this
=NUM(SUM({<[MonthYear Numeric] = {">=$(=AddMonths(Max([MonthYear Numeric]),-12))<=$(=Max([MonthYear Numeric]))"}>}Sales),'€#,##0')
Try this
=NUM(SUM({<[MonthYear Numeric] = {">=$(=AddMonths(Max([MonthYear Numeric]),-12))<=$(=Max([MonthYear Numeric]))"}>}Sales),'€#,##0')
Thank you ! worked perfectly !