Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
Have following issues in my pivot table
SHIFT | START SHIFT | END SHIFT | DATE SHIFT | WEIGHT HANDLED | QTY | PARTNO |
---|---|---|---|---|---|---|
S1 | 14:00 | 21:45 | 14/01/2013 | 125 | 15 | CRATE |
100 | 10 | CASES | ||||
50 | 5 | CASES | ||||
TOTAL | 0 | 0 | ||||
Total gives my 0 ?? Any clues ?
SHIFT | START SHIFT | END SHIFT | DATE SHIFT | TOOL | WEIGHT HANDLED | QTY | PARTNO |
---|---|---|---|---|---|---|---|
S1 | 14:00 | 21:45 | 14/01/2013 | CRANE1 | 125 | 15 | CRATE |
100 | 10 | CASES | |||||
50 | 5 | CASES | |||||
CRANE 2 | 125 | 15 | CRATE | ||||
100 | 10 | CASES | |||||
50 | 5 | CASES | |||||
I inserted a new field tool but only want to have the view as below
SHIFT | START SHIFT | END SHIFT | DATE SHIFT | TOOL | WEIGHT HANDLED | QTY | PARTNO |
---|---|---|---|---|---|---|---|
S1 | 14:00 | 21:45 | 14/01/2013 | CRANE1 | 125 | 15 | CRATE |
CRANE2 | 100 | 10 | CASES | ||||
50 | 5 | CASES | |||||
Thanks for helping me out with these issues
current expression used :
=
sum({$<MCH_CODE={"SH*"}>}WEIGHT_HANDLED)