Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a pivot table with multiple dimension, and I am trying to cumulate the values based on the logistic Type (header) as shown below
LAB | LeadTime | LogisticOrderType | Invoice Date | 05/03/2017 | ||
MTCS | A | AV | 4 | 4 | 11% | |
MTCS | A | CD | - | |||
MTCS | A | AP | - | |||
MTCS | B | AV | 24 | 28 | 80% | |
MTCS | B | RR | 1 | |||
MTCS | B | FF | 4 | |||
MTCS | B | CF | - | |||
MTCS | B | CD | 295 | |||
MTCS | B | AP | 6 | |||
MTCS | C | AV | 7 | 35 | 100% | |
MTCS | C | RR | 2 | |||
MTCS | C | FF | - | |||
MTCS | C | CF | - | |||
MTCS | C | CD | 736 | |||
MTCS | C | AP | 63 |
for eg, AV in Logistic type repeats for A, B, C I want to add 4 to 24 for B and 7 to 28
AV has to cumulate to 100% in C
Please help I have attached a file as well
Hi,
May be as variant in attached file. I especially did not delete the intermediate expressions (made them hidden in the settings), so that the computational logic was understandable.
Regards,
Andrey