topic Calculated Dimension and Total in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289250#M584003 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In a pivot table, I'm trying to calculate the total in one of my expressions by ignoring one dimension (Dimesion 1) and grouping by the other (Calculated Dimension 2).&nbsp; Any suggestions for how to do this?&nbsp; I know the usual formula for this would be Sum( total &lt;[Dimension 2]&gt; widgets), but I can't figure out how to get it to work.&nbsp; I don't think I can build the calculated dimension as a variable or hard code it either- it adjusts based on input boxes in my file.</P><P></P><P></P><P>Thoughts?</P><P></P><P>Thanks for your time,</P><P></P><P>Claire</P></BODY></HTML> Tue, 01 Nov 2011 20:48:14 GMT 2011-11-01T20:48:14Z Calculated Dimension and Total https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289250#M584003 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In a pivot table, I'm trying to calculate the total in one of my expressions by ignoring one dimension (Dimesion 1) and grouping by the other (Calculated Dimension 2).&nbsp; Any suggestions for how to do this?&nbsp; I know the usual formula for this would be Sum( total &lt;[Dimension 2]&gt; widgets), but I can't figure out how to get it to work.&nbsp; I don't think I can build the calculated dimension as a variable or hard code it either- it adjusts based on input boxes in my file.</P><P></P><P></P><P>Thoughts?</P><P></P><P>Thanks for your time,</P><P></P><P>Claire</P></BODY></HTML> Tue, 01 Nov 2011 20:48:14 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289250#M584003 2011-11-01T20:48:14Z Calculated Dimension and Total https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289251#M584004 <HTML><HEAD></HEAD><BODY><P>Do you need any additional information for this?&nbsp; I'd appreciate any and all help!</P><P></P><P>Thanks in advance,</P><P></P><P>Claire</P></BODY></HTML> Tue, 08 Nov 2011 21:58:30 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289251#M584004 2011-11-08T21:58:30Z Calculated Dimension and Total https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289252#M584005 <HTML><HEAD></HEAD><BODY><P>Hi Claire,</P><P></P><P>Can you upload an example?</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 08 Nov 2011 22:13:50 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Total/m-p/289252#M584005 2011-11-08T22:13:50Z