Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
I'm having a pivot table which looks like below:
Here I'm having Expression as Downtime-Cat-Desc. and Downtime , where in Downtime -Cat-Desc. I'm having few names like "Paro Fin de Semana" and in Downtime I'm having some time data.
I need them in this way as Horizontal look: Similar I want with Scrap-Cat-Desc. and Scrap.
Downtime-Cat-Desc. | Arranque/Paro Máquina | Falta de planificación | Cambio de molde/Ajuste | Equipo intermedio | Fallo en sopladora | TPM | Problema/Error logística | Otros (fugas, molino, etc.) | Fallo herramientas | - |
| 247:13:37 | 118:07:41 | 33:40:00 | 13:14:18 | 9:33:12 | 8:00:00 | 2:00:00 | 1:46:39 | 1:09:44 | 1533:23:29 |
Please see the attachment 123.qvw for more details .
Thanks in advance.
AS
Add those fields as dimensions instead of expressions. Then drag those dimensions to above the expressions so they are pivoted to horizontal layout.
Add those fields as dimensions instead of expressions. Then drag those dimensions to above the expressions so they are pivoted to horizontal layout.
Gylberst is right