Forum Discussion
Solved
Show values between dates selection
Hi all, I have a report page which shows Item sales details. Now I want to map cost of the item on each line. The Cost table is like as follows: ItemNumber PostingDate UoM Cost 3002...
i did the data transform in PQ, pls see if this is what you want
ryan_mayu thank you for the quick response. my requirement is to show the cost price on respective sales line.
| Date | Item | Quantity | Cost | Total Cost | Selling Price | Total | Margin |
| 02/01/2024 | 3002383 | 2 | 0.09 | 0.18 | 0.115 | 0.23 | 0.05 |
| 03/01/2024 | 3002383 | 1 | 0.09 | 0.09 | 0.115 | 0.115 | 0.025 |
| 05/01/2024 | 3002383 | 10 | 0.095 | 0.95 | 0.115 | 1.15 | 0.2 |
| 10/01/2024 | 3002383 | 5 | 0.095 | 0.475 | 0.115 | 0.575 | 0.1 |
| 12/01/2024 | 3002383 | 2 | 0.1 | 0.2 | 0.115 | 0.23 | 0.03 |
i did the data transform in PQ, pls see if this is what you want