Pivot Table help with Expression????

[amit_saini]

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

[Gysbert_Wassenaar · Accepted solution]

Add those fields as dimensions instead of expressions. Then drag those dimensions to above the expressions so they are pivoted to horizontal layout.

[sujeetsingh]

Gylberst is right