Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i would like to perform a point in time report.
i am currently trying to point back to the previous year and week based upon my selection.
my selection in this case is 201531 so i would like to return the values for 201431.
please see my attempt below
sum(<{[Year Week] = {$(=(Only(Year)-1)) & $(=Only(Week))}>}
Sales)
Try sum(<{[Year Week] = {$(=(Only(Year)-1)),$(=Only(Week))}>} Sales)