I need to see the comparative month to month with set analysis
My KPI is not working. It does'nt return the value according to my selection of months.
It is linked to a set analysis condition to the comparative considering only sales PROMOTIONS.
When you do not have any filter it returns me the difference between September x August (OK, that's what I want Too), but when I select August for example, it does not return any value to me, as if error in the formula. I need to see the comparative month to month depending on my selections.
selected october - KPI shows difference (%) between october x september
selected september - difference (%) between september x august
selected augost - difference (%) between augost x july