Create a report from a Data Model that shows values only

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

Are you still using Excel 2010? If not, please update your profile. This would be a prime candidate for PowerQuery, if you have a newer version of Excel.

There are instructions at the top of the page explaining how to attach your sample workbook.

Sorry - the workbook is useless!

We need to see the source data (just a few rows, not thousands!) and a small mock-up showing how you want the processed data to look.

Thanks - when this is provided, I'll take a look.

You cannot get from the pivot table to what you want because the data you need isn't in the pivot table.

This is why I asked for RAW data - forget the pivot table.

No, no, no!!!

PLEASE put a sample of raw data into one workbook along with the layout you want. Sorry - you are making this unnecessary fiddly for us!

In which of your attachments will I find everything together?

Really sorry - I am not getting this at all. Thank you for putting everything into one workbook - i was going to suggest a PowerQuery solution, but I see you know PQ so should be able to work it out that way yourself. Therefore, I will assume that a PQ solution will not be suitable for you.

In the workbook, what do you mean by filtering the list using the smaller source table? I don't believe you are actually showing us what you want, and if you are, it doesn't match your annotations.

I'll step aside - you need fresh eyes on this.