I have a Data Model with two tables in it. Simply these are;
Order - which has an Order ID and a Creation Date field
Order Line - which has a line for each line against the order and has fields for Item Code and Quantity
A 1:Many relationship exists between Order and Order Line.
I want to be able to create a table/report that shows each Order (Order ID) and the Item Codes against that order. A Timeline slicer will allow me to restrict the period of time that is viewed.
(Adding Item Code as a Row is the format I want, but it shows all of the Item Codes against each Order, not just the Item Codes for that Order)
A Pivot Table does not really work here because the Item Code field is text, so it only shows Count if used as a Value. I want to see the actual Item Code.
Can someone please guide me to a better solution (bearing in mind that my source tables will have a lot more fields in time).
Thanks
Bookmarks