So, basically the revenue is at an order-item level. So, do you need to compare the revenue YOY for each order and/or item combination? Will the order number be the same across different years? If so, you can always include the order and/or item too to the join condition shown above. If not, please explain what your needs are.

Yes, I need to compare the revenue YOY for each DAY, WEEK, MONTH (data nivel). The importance of order-item level is to show the data in all different categories here. The order number is not the same across the years (its different).

I have done a Union of the data 4 times, once each for YEAR, MONTH, WEEK and DAY. This data is then joined with another Union of the same data 4 times. I have used a calculated join. You can include an additional join for an Item as required.

\

I am using the following LOD calculations:

I have a parameter to select the period and have an additional filter to ensure the data join is correct. (I did observe some incorrect data being joined, and could not figure that out for now. So, had to use the Data Join filter as shown below).

You now have the required outputs:

You can probably achieve the above functionality using Custom SQL on Excel files on Windows systems. Since, I am on a Mac, this ended up being slightly complex.