topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1413118#M611949 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Does anyone know what I can't add columns to my pivot table?&nbsp; For some reason, when I add a dimension such as Currency or Sq.Ft. or Expiration, the data doesn't display it as a separate repeating column like it would in an excel pivot table; however, it displays it as a filter instead?&nbsp; In order to get around this, I have created one straight table and one pivot table but was wondering if there is anyway to display all the data in a pivot table with repeating labels just as the excel source data shows.&nbsp; Thank you!</P></BODY></HTML> Wed, 30 Aug 2017 22:23:58 GMT powerqlik 2017-08-30T22:23:58Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1413118#M611949 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Does anyone know what I can't add columns to my pivot table?&nbsp; For some reason, when I add a dimension such as Currency or Sq.Ft. or Expiration, the data doesn't display it as a separate repeating column like it would in an excel pivot table; however, it displays it as a filter instead?&nbsp; In order to get around this, I have created one straight table and one pivot table but was wondering if there is anyway to display all the data in a pivot table with repeating labels just as the excel source data shows.&nbsp; Thank you!</P></BODY></HTML> Wed, 30 Aug 2017 22:23:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1413118#M611949 powerqlik 2017-08-30T22:23:58Z