Create a Weekly Sales Report

Method 1 - Columns by week

Open the editor and lay the groundwork

1. Navigate to the Metric report and create a new report

2. Switch to Design editor.

   

3. In the dimensions, select Product (e.g., Product).

   

4. Add the measure: Sales – POS Accounts (unit = Unit).

   

Define the interval of a week

5. Open Timeframe > select Trailing.

   

6. Enter 1 week, then set the end period (e.g.: January 5th 2025 – January 11th 2025).

   
   

7. Click Apply to display the POS sales for this week.

   

8. Rename the column for a dynamic name (e.g.: POS Sales W{s:WW-YYYY}).

   

Create the other weeks by duplication

9. Duplicate the column.

   

10. In Timeframe, adjust Ending on → Weeks ago (e.g.: 1, 2, 3, …) to select each previous week.

    

11. Save after each change and repeat until you have the desired number of weeks (e.g.: first 6, last 52).

    

12. Result: column view, 1 column = 1 week, by Product.

    

Method 2 - Report with the “Week” dimension + YoY comparison

Build the “last 52 weeks” base

1. Stay in Design editor with Product selected.

   

2. Add the measure : Sales – POS Accounts (Unit).

   

3. Timeframe : select From To (end = Current Reference Date).

   

4. Click Apply : you will obtain the total per product (over 52 weeks).

Group by week

5. Add the dimension Week Number (drop it into the rows).

   

6. Verify that the aggregation displays one line per week (W01…W52) under each Product.

Duplicate the measure to compare with the previous year

7. Duplicate the measure.

   

8. Measure A = This Year (POS {s:YYYY}) : retain From TO on the current reference date.

9. Measure B = Last Year (POS {s:YYYY}) : same window but shifted by 1 year (or use the “previous year” option, depending on your environment).

   
   

   10. You now have two columns : TY and LY, by Week Number and Product.

       

Calculate Delta and % Variation

11. Calculated measure %Δ : %Δ = (TY − LY) / LY.

    

12. Display TY | LY | Delta | %Δ for each Week Number and Product.

13. Analysis example: identification of weeks with growth (e.g.: +9%, +63%) vs decline.

    

You can insert the Brand dimension above Product for a drill-down Brand → Product → Week Number.