https://community.qlik.com/t5/App-Development/Convert-pivot-table-total-to-field-to-a-calculated-field-and-add/m-p/1541265#M39061 <P>I am building a pivot table and trying to do the following:</P><P>1. I would like to add a filter option to the TOTAL column.</P><P>2. I would like to build charts off the TOTAL column (e.g. I want to create a stacked bara chart with values from the TOTAL column).&nbsp; Is there any way to do this?&nbsp; Can I convert the TOTAL column into a data field or a calculated field so that I can use that column to build additional charts?</P><P>I'm very new to QlikSense and am not sure how to export and attach the model to this question (I'm using the web version) so I took a screenshot.&nbsp; Any help anyone can offer is appreciated!</P><P>&nbsp;</P><P>Thanks.</P> Sat, 16 Nov 2024 06:38:44 GMT AmyChen 2024-11-16T06:38:44Z https://community.qlik.com/t5/App-Development/Convert-pivot-table-total-to-field-to-a-calculated-field-and-add/m-p/1541265#M39061 <P>I am building a pivot table and trying to do the following:</P><P>1. I would like to add a filter option to the TOTAL column.</P><P>2. I would like to build charts off the TOTAL column (e.g. I want to create a stacked bara chart with values from the TOTAL column).&nbsp; Is there any way to do this?&nbsp; Can I convert the TOTAL column into a data field or a calculated field so that I can use that column to build additional charts?</P><P>I'm very new to QlikSense and am not sure how to export and attach the model to this question (I'm using the web version) so I took a screenshot.&nbsp; Any help anyone can offer is appreciated!</P><P>&nbsp;</P><P>Thanks.</P> Sat, 16 Nov 2024 06:38:44 GMT https://community.qlik.com/t5/App-Development/Convert-pivot-table-total-to-field-to-a-calculated-field-and-add/m-p/1541265#M39061 AmyChen 2024-11-16T06:38:44Z