topic Add columns to a pivot table in QlikView https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49800#M782909 <HTML><HEAD></HEAD><BODY><P style="font-family: Calibri; font-size: 11.0pt;">Hi all, </P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">I'm working with a pivot table where rows are a calculated dimension and columns are a dimension.</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">The measure expression is:</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">On presentation tab, I've choosen to show partial&nbsp; sums. I'm I able to add a new column that would calculate the relative value of total sums? For example, for Premium it would be 44% because it's 19607/44118.</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Add columns to a pivot table https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49800#M782909 <HTML><HEAD></HEAD><BODY><P style="font-family: Calibri; font-size: 11.0pt;">Hi all, </P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">I'm working with a pivot table where rows are a calculated dimension and columns are a dimension.</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">The measure expression is:</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">On presentation tab, I've choosen to show partial&nbsp; sums. I'm I able to add a new column that would calculate the relative value of total sums? For example, for Premium it would be 44% because it's 19607/44118.</P><P></P><P style="font-family: Calibri; font-size: 11.0pt;">Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49800#M782909 Anonymous 2020-11-25T16:16:04Z Re: Add columns to a pivot table https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49801#M782910 <HTML><HEAD></HEAD><BODY><P>Please share sample data and expected output. Thanks.</P></BODY></HTML> Mon, 19 Mar 2018 17:10:04 GMT https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49801#M782910 Digvijay_Singh 2018-03-19T17:10:04Z Re: Add columns to a pivot table https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49802#M782911 <HTML><HEAD></HEAD><BODY><P>It would be something like the image attached.</P><P>Thank you!</P></BODY></HTML> Mon, 19 Mar 2018 17:28:11 GMT https://community.qlik.com/t5/QlikView/Add-columns-to-a-pivot-table/m-p/49802#M782911 Anonymous 2018-03-19T17:28:11Z