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...

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 wk 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

Content aside

  • Status Answered
  • 2 wk agoLast active
  • 1Replies
  • 35Views
  • 2 Following