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...
7 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
-
As you told me I created the ticket and Musgrace IT staff range me few days ago. I told her what I need and she told me that she will come back to me... but in the meantime I was able to create what I need myself (photo attached). I still have to do some work on it regarding layout, filters, etc but this is what I needed :) thank you all for you help
Actually, maybe you can save my time... how I can add filter (what kind of) beside year filter which will allow me to choose date from xxx to yyy. Now I have to click twice on my day and I can click days manually (left corner of the photo)...
-
Nevermind... I found it :)
