topic Re: Suming using dimensions in chart in QlikView https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753784#M268599 <HTML><HEAD></HEAD><BODY><P>Provide sample data please.</P></BODY></HTML> Mon, 03 Nov 2014 12:22:02 GMT MK_QSL 2014-11-03T12:22:02Z Suming using dimensions in chart https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753783#M268598 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 10pt; font-family: 'Courier New';">Hi</SPAN></P><P></P><P><SPAN style="font-family: 'Courier New'; color: #000000; font-size: 10pt;">I have the attached table to show Target Full Year and Target YTD in Dimension 2 for test 1.&nbsp; I want to show a sum of the Regions to show in Dimension 1 when nothing is expanded so that the metric shows a total of all 4 regions.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Courier New'; color: #000000;">Any Help would be appreciated</SPAN></SPAN></P><P></P><P><SPAN><SPAN style="font-size: 10pt;">Also if possible on the variance column if the outcome is &gt; than 100% then I want it to show &gt;100% rather than the figure.&nbsp; is this possible</SPAN>.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thanks</SPAN></P><P></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 12pt;">Rhona</SPAN></P></BODY></HTML> Mon, 03 Nov 2014 12:20:15 GMT https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753783#M268598 rcorcoran 2014-11-03T12:20:15Z Re: Suming using dimensions in chart https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753784#M268599 <HTML><HEAD></HEAD><BODY><P>Provide sample data please.</P></BODY></HTML> Mon, 03 Nov 2014 12:22:02 GMT https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753784#M268599 MK_QSL 2014-11-03T12:22:02Z Re: Suming using dimensions in chart https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753785#M268600 <HTML><HEAD></HEAD><BODY><P><BR />sample now attached</P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Nov 2014 13:41:05 GMT https://community.qlik.com/t5/QlikView/Suming-using-dimensions-in-chart/m-p/753785#M268600 rcorcoran 2014-11-03T13:41:05Z