Forum Discussion
Filtering Data on Order Date but Display Values based on Invoice Date in a Matrix
Hi everyone - looking for some help with filtering and displaying data with multiple dates. I recieve daily order data that includes 3 important pieces of information: Order Date - date the ord...
If possible provide a sample dataset and a expected result. That will be more understable
I appreciate the help. Here is a screenshot with my data removed from it:
The table on the left will show orders by order date. IE all the orders that came in during a given time frame. The table on the right then will show when those same orders will ship/invoice.
Here is an example of what my data looks like:
| Customer | Order Amount | Order Date | Invoice Date |
| Bob | 10 | 3/21/2023 | 4/3/2023 |
| Cindy | 20 | 3/21/2023 | 5/6/2023 |
| Jeff | 40 | 3/20/2023 | 6/1/2023 |
I can get the table on the left to work, but the table on the right I am struggling to get to show the same orders that I am slicing for by order date to then matrix out based on their invoice date(month).
Any help is appreciated.
Brad