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...
5 replies
-
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
-
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
-
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"
-
-
Hi Lukasz, and will reach out directly. Thanks again for the questions. Happy selling
