topic Setting up pivot table with monthly and YTD data in QlikView https://community.qlik.com/t5/QlikView/Setting-up-pivot-table-with-monthly-and-YTD-data/m-p/1361964#M824629 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I want to set up a pivot table showing a couple of columns starting with monthly data (LY, BUD, ACT) and then YTD (LY, BUD, ACT) in one pivot table. How do you set this up? So basically the monthly data in the below example needs to be from June-17 and YTD April till June. Is this possible in one table?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171253_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT tim_leijen 2020-11-25T16:16:04Z Setting up pivot table with monthly and YTD data https://community.qlik.com/t5/QlikView/Setting-up-pivot-table-with-monthly-and-YTD-data/m-p/1361964#M824629 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I want to set up a pivot table showing a couple of columns starting with monthly data (LY, BUD, ACT) and then YTD (LY, BUD, ACT) in one pivot table. How do you set this up? So basically the monthly data in the below example needs to be from June-17 and YTD April till June. Is this possible in one table?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171253_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Setting-up-pivot-table-with-monthly-and-YTD-data/m-p/1361964#M824629 tim_leijen 2020-11-25T16:16:04Z