Hi there,
I’m currently doing the Business Analyst with Tableau course and I can’t understand the behavior of Excel in screen number 6:
The instructions say to create a pivot table with these fields:
- order_id along Rows
- Sum of sales inside Values
When I do this, I get a total of 5010 rows. But the original sheet (“orders”) contains 9995 rows.
Just as an exercise, I created a pivot table with only “sales” or “profits” in the rows. And the result is always a different number of rows.
Why is that? As there are no blank values, it should always be 9995 rows, right?
EDIT: I would like to add that on screen 7, the solution in the corresponding excel sheet for the goal-seeking task is incorrect as the profit margin is left out of the equation to calculate the profits.
Hi @fischerandreas,
Great question! I tried to find the lesson you are referencing but the link took me to a different lesson. Can you add the link to the screen 6?
Without reviewing the dataset, are there any duplicate order_ids? Did an order_id have multiple products? So, when you run the pivot table, you get the aggregate or sum by order_id. That may cause less rows because now all the orders are rolled into one row???
Could you please report the EDIT for screen 7 to the Technical Support Team of Dataquest? Just click the ? button in the upper-right corner of the platform screen where you detected this issue, click Share Feedback , describe the problem, and send the ticket. Thanks!
3 Likes
Hi Cassandra,
Thanks a lot for the quick reply and you are right, there are multiple duplicate order_ids in the column. I somehow didn’t spot that!
I also reported the wrong calculation in the solution sheet, as you have suggested.
3 Likes