topic Need the total row to use different calculation in QlikView https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796003#M1040763 <HTML><HEAD></HEAD><BODY><P><IMG alt="Sample.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/73001_Sample.png" style="width: 569px; height: 388px;" /></P><P>On the attached application the column labeled Charge / Sow takes the average number of sows for the date range selected and divides the Charges by that amount which works fine on the individual farm basis, but this caused me a problem with the total row. I need the total row&nbsp; to calculate by dividing the total Charge ($4,388.72) by the Avg Sows on Hand (65,409) and return the correct Charge/Sow (.0671). Any help on this will be greatly appreciated.</P></BODY></HTML> Mon, 08 Dec 2014 15:46:15 GMT Anonymous 2014-12-08T15:46:15Z Need the total row to use different calculation https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796003#M1040763 <HTML><HEAD></HEAD><BODY><P><IMG alt="Sample.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/73001_Sample.png" style="width: 569px; height: 388px;" /></P><P>On the attached application the column labeled Charge / Sow takes the average number of sows for the date range selected and divides the Charges by that amount which works fine on the individual farm basis, but this caused me a problem with the total row. I need the total row&nbsp; to calculate by dividing the total Charge ($4,388.72) by the Avg Sows on Hand (65,409) and return the correct Charge/Sow (.0671). Any help on this will be greatly appreciated.</P></BODY></HTML> Mon, 08 Dec 2014 15:46:15 GMT https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796003#M1040763 Anonymous 2014-12-08T15:46:15Z Re: Need the total row to use different calculation https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796004#M1040764 <HTML><HEAD></HEAD><BODY><P>Use the dimensionality() function.</P><P></P><P>If(Dimensionality() = 1, &lt;Expression you want to use for total here&gt;,</P><P>&lt;Expression for rows here&gt;)</P></BODY></HTML> Mon, 08 Dec 2014 15:50:32 GMT https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796004#M1040764 jpapador 2014-12-08T15:50:32Z Re: Need the total row to use different calculation https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796005#M1040765 <HTML><HEAD></HEAD><BODY><P>That helps, but the other part of my problem is that I can do a SUM(Total for the Other Costs), but I cannot do this for the FarrEndSowsOnhand because it is an average of the period selected. Any further suggestions?</P></BODY></HTML> Mon, 08 Dec 2014 16:11:59 GMT https://community.qlik.com/t5/QlikView/Need-the-total-row-to-use-different-calculation/m-p/796005#M1040765 Anonymous 2014-12-08T16:11:59Z