Forum Discussion
erhan_79
Post Prodigy
Post ProdigyPivot Creating help
Hi there ; i nned your kind help about below issue thanks in advance for your kind supports so , i have two table as below , left one is request table , and right one is the delivery ta...
erhan_79 ,
Find the file attached after the signature.
- Created Dimension
- Create Date table
- Month Sort column in date table -Marked as sort for month year
- Created new measures
erhan_79Post Prodigy
Post ProdigyDear amitchandak
thank you very much , i will wait here for your reply
i am sending as below i hope it works for you
table request
| Purchase No | Model | Request Date | Qty | Vendor |
| 1 | Finish Good | 1.02.2020 | 10 | Vendor A |
| 2 | Accessories | 1.02.2020 | 20 | Vendor A |
| 3 | Finish Good | 1.04.2020 | 20 | Vendor B |
| 4 | Finish Good | 1.04.2020 | 10 | Vendor B |
| 5 | Accessories | 1.02.2020 | 10 | Vendor A |
| 6 | Accessories | 1.04.2020 | 15 | Vendor B |
Table Delivery
| Inbound No | Model | Delivery Date | Qty | Vendor |
| 7 | Finish Good | 1.02.2020 | 5 | Vendor A |
| 8 | Accessories | 1.02.2020 | 10 | Vendor A |
| 9 | Finish Good | 1.04.2020 | 10 | Vendor B |
| 10 | Finish Good | 1.04.2020 | 20 | Vendor B |
| 11 | Accessories | 1.02.2020 | 5 | Vendor A |
| 12 | Accessories | 1.04.2020 | 10 | Vendor B |
amitchandak
Super User
Super Usererhan_79 ,
Find the file attached after the signature.
- Created Dimension
- Create Date table
- Month Sort column in date table -Marked as sort for month year
- Created new measures
- erhan_79
thank you very much dear amitchandak it is working have a good day.