0

How to create quantities sales report

Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product linked with specific department and subdepartment on each day for whole week, eg..:

PRODUCT   MON 1ST    TUE 2ND    WEDN 3RD    THUR 4TH    FRI 5TH    SAT 6TH    SUN 7TH

"A"               23 UNITS    12 UNITS   34 UNITS       24 UNITS    87 UNITS   67 UNITS   54 UNITS

"B"              32 UNITS    21 UNITS   43 UNITS       42 UNITS    78 UNITS   76 UNITS   45 UNITS

"C"              12 UNITS    34 UNITS   56 UNITS       89 UNITS    25 UNITS   78 UNITS   98 UNITS

ETC...

4 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi  ,

    Assuming you have already built your model or connected to your database and also assuming you have the appropriate attributes and measures available, this is very simple.

    Open a new Discover and select your data model. Simply drag the departments into the Rows Drop Zone, the Days of the Week into the Columns DropZone and select the Units Measure. I've also selected Full Week as a filter so I can examine individual weeks.

    Hope that helps,

    Ian

    • Senior Director of Product
    • Ian_Macdonald
    • 11 days ago
    • Reported - view

    Hi 

    Fair enough! 🙂

    Ok, what is your starting position? What data do you have and in what format? If you can share an example of dummy or anonymised data in the same format, we can walk you through the process.

    Cheers,

    Ian

      • Lukasz_Godon
      • 4 days ago
      • Reported - view

      Hi  

      So I am working in retail and with old pyramid I knew how to create sales reports for specific departments:

      1. Bakery

      - Fresh

      - Scratch

      - Prepack

      2. Deli

      3. Meat

      - Meat serve over

      - Fish serve over

      - Meat prepack

      - Fish prepack

      4. Produce

      5. Dair

      6. Provision

      7. Frozen

       

      What I am looking for is report which allows me to see units sales of all products linked with above departments and/or subdepartments in specific time frame (e.g. from 01.12.2023 to 31.12.2023).

      Photo 1&2 shows my dep and sub dep with € sales but I need to see units sales of all products in dep and/or in sub dep...

      this report was already done and uploaded to "our pyramid"

Content aside

  • Status Answered
  • 4 days agoLast active
  • 4Replies
  • 43Views
  • 2 Following