Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't seem to get totals into my pivot chart.
I'm looking for this result:
BU | Cluster | Site | Process | Activity | UOM | Tot Act. Hr | 08-09 Act. Hr | 09-09 Act. Hr | 10-09 Act. HR |
---|---|---|---|---|---|---|---|---|---|
Inbound | Unload | Pallets | 147 | 60 | 40 | 47 | |||
Outbound | Pick | Boxes | 330 | 110 | 122 | 98 | |||
Outbound | Load | Pallets | 130 | 50 | 50 | 30 | |||
Operations | Supervision | Hour | 36 | 16 | 8 | 12 |
In my example I've added 3 days, but it should be possible to show every day of the year.
For the column Tot Act. Hr I'm trying to add a calculated dimension - but I'm not getting the calculation right.
Can anyone help me out?
You need to use the aggr function in the calculated dimension. See attached qvw.
You need to use the aggr function in the calculated dimension. See attached qvw.
aggr(sum([Total Act],Process)