topic Pivot table total on second pivoted dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-total-on-second-pivoted-dimension/m-p/1092053#M363159 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Is it possible to have partial sums on the second pivoted dimension?</P><P style="text-align: left;"></P><P style="text-align: left;">My pivot table has this structure:</P><P style="text-align: left;"><IMG alt="pivot.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111642_pivot.png" style="width: 620px; height: 168px;" /></P><P style="text-align: left;">I need to split the grand total column into Total and Mava.</P><P style="text-align: left;"></P><P style="text-align: left;">My workaround is to create a separate table without the Year dimension where the years are summed up for Total and Mava. But since there is no way to synchronize the scrolling between charts in Qlikview, the separate table becomes an almost useless solution.</P><P style="text-align: left;"></P><P style="text-align: left;">Is this possible to customize the total column?</P></BODY></HTML> Thu, 14 Jan 2016 14:28:37 GMT 2016-01-14T14:28:37Z Pivot table total on second pivoted dimension https://community.qlik.com/t5/QlikView/Pivot-table-total-on-second-pivoted-dimension/m-p/1092053#M363159 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Is it possible to have partial sums on the second pivoted dimension?</P><P style="text-align: left;"></P><P style="text-align: left;">My pivot table has this structure:</P><P style="text-align: left;"><IMG alt="pivot.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111642_pivot.png" style="width: 620px; height: 168px;" /></P><P style="text-align: left;">I need to split the grand total column into Total and Mava.</P><P style="text-align: left;"></P><P style="text-align: left;">My workaround is to create a separate table without the Year dimension where the years are summed up for Total and Mava. But since there is no way to synchronize the scrolling between charts in Qlikview, the separate table becomes an almost useless solution.</P><P style="text-align: left;"></P><P style="text-align: left;">Is this possible to customize the total column?</P></BODY></HTML> Thu, 14 Jan 2016 14:28:37 GMT https://community.qlik.com/t5/QlikView/Pivot-table-total-on-second-pivoted-dimension/m-p/1092053#M363159 2016-01-14T14:28:37Z