This images shows the Orders table and the Order Items table joined on the Order ID column.

The Orders table data is:
Order ID Order Total
1001 50.97
1002 1249.91
The Order Items table data is:
Order ID Product ID Quantity
1001 40 1
1001 63 2
1002 29 1
1002 14 3
1002 2 1
This table shows the query output based on the Order Items table grain. It shows that when the dataset is queried, that the Order Total is duplicated for each order item.
Order ID Product ID Order Total Quantity
1001 40 50.97 1
1001 63 50.97 2
1002 29 1249.91 1
1002 14 1249.91 3
1002 2 1249.91 1