Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Last 4 weeks comparison calculation based on Slicer date calculation

last 4 weeks comparison calculation based on Slicer date calculation

Start of the week will be Monday.
Laast 4 weeks comparison calculation based on Slicer date calculation
Comparison = (Current  4 weeks Sales  - Previous 4 weeks Sales) / Previous 4 weeks Sales

Please find below screenshot.

 




Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    2 years ago

    Hi, Anonymous 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,
      It should like below visual :

       

      only change is Last 4weeks calculation instead of weeks