@lalprasanth
you can only receive the values for categorys that are under the top mover. I guess you want to visualise all categorys from that dimenions.
I suggest to use a table and the following calculations:
- periodOverPeriodDifference
- periodOverPeriodPercentDifference
- periodOverPeriodLastValue
Example: periodOverPeriodDifference(count(ifelse(dateDiff([YOUR NEWEST DATE], [YOUR DATEFIELD], “WK”) < 2, [YOUR MEASURE] , NULL)),[YOUR DATEFIELD],WEEK, -1)
Group by: Category and Date (Weeks)
Value: Your Calculations
Filter: Excluding null values for your calculation and filter for the latest two weeks.
Regards Nico