Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone @MayilVahanan @mbj
PFA
In this i want wow(Week on Week )Calculation but there is something like i have an filter for week .in week we have 4 weeks for example 27,28,29and 30. Suppose if we select 27 and 29 in week filter that the current week is 29 but previous is 28 and if we does not select anything in week filter then that means current week is 30 and previous week is 29. so i want wow for buyable selection please help me in this .
Hi, so if the user select 29 and 27, you still want to compare 29 and 28? You can do that with set analysis, in example to fix to calcualte the differnce between the higher week possible and the previous it would be:
Sum({<Week={$(=Max(Week))}>} Sales)-Sum({<Week={$(=Max(Week)-1)}>} Sales)
Can u help me in error
[Buyable Selection] in green means that there is no field with that name, if you use a correct field name it should be shown in orange.
If it's master measure it bwill show blue, maybe it's just another expresson in the cahrt but you can't use another expression to apply set analysis on it, copy the expressionand add the needed set analysis (the week)