Hi all
I have a use case I'm been struggling to solve on my own so I come to seek your help!
My power pivot data table looks like that:
<tbody>
</tbody>
And I'd like to have as an output a pivot table which would look like:
<tbody>
</tbody>
basically this would the result of SUMPRODUCT (quantity * order_day) and SUMPRODUCT ( quantity * receive_day) but I would be able to apply filters on products and supplier in my pivot table.
thanks a lot for your help
thomas
I have a use case I'm been struggling to solve on my own so I come to seek your help!
My power pivot data table looks like that:
product | supplier | quantity | order day | receipt day |
A | supplier1 | 45 | Monday | Wednesday |
B | supplier1 | 456 | Monday | Thursday |
C | supplier1 | 86442 | Monday | Wednesday |
D | supplier1 | 74 | Tuesday | Friday |
E | supplier2 | 784 | Wednesday | Friday |
F | supplier2 | 768 | Tuesday | Friday |
G | supplier2 | 291 | Tuesday | Saturday |
H | supplier2 | 75 | monday | Friday |
I | supplier2 | 947 | Wednesday | Thursday |
<tbody>
</tbody>
And I'd like to have as an output a pivot table which would look like:
Day | Order Day | Receive Day |
Monday | 87018 | 0 |
Tuesday | 1133 | 0 |
Wednesday | 1731 | 86487 |
Thursday | 0 | 1403 |
Friday | 0 | 1701 |
Saturday | 0 | 291 |
Sunday | 0 | 0 |
<tbody>
</tbody>
basically this would the result of SUMPRODUCT (quantity * order_day) and SUMPRODUCT ( quantity * receive_day) but I would be able to apply filters on products and supplier in my pivot table.
thanks a lot for your help
thomas