topic Re: Can you do a different aggregate calculation in the total of a pivot table . in QlikView https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501735#M556487 <HTML><HEAD></HEAD><BODY><P>Hi Oliver,</P><P></P><P>Since the pivot table doesn't have the option to change the Total mode of the expressions in the properties dialog like the straight table, you will have to do that in your expressions. If it's just a simple average of the calculations you can achieve that using the AGGR function (advanced aggregation). For example:</P><P></P><P>avg(aggr(sum(Value),Dimension))</P><P></P><P>Please let me know if you need more information,</P><P></P><P>Cesar</P></BODY></HTML> Fri, 19 Jul 2013 15:34:34 GMT cesaraccardi 2013-07-19T15:34:34Z Can you do a different aggregate calculation in the total of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501732#M556484 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp;&nbsp; Can you do a&nbsp; different aggregate calculation in the total&nbsp; of a pivot table .</P><P></P><P></P><P>I have a pivot table that has a calculation as the measure</P><P></P><P>I would like to have the total as an avg of the rows</P></BODY></HTML> Fri, 19 Jul 2013 15:16:43 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501732#M556484 2013-07-19T15:16:43Z Re: Can you do a different aggregate calculation in the total of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501733#M556485 <HTML><HEAD></HEAD><BODY><P>=if( Dimensionality() = 1</P><P>&nbsp;&nbsp;&nbsp; , sum(Qty)</P><P>&nbsp;&nbsp;&nbsp; , avg(Qty)</P><P>&nbsp;&nbsp;&nbsp; )</P></BODY></HTML> Fri, 19 Jul 2013 15:22:42 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501733#M556485 luciancotea 2013-07-19T15:22:42Z Re: Can you do a different aggregate calculation in the total of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501734#M556486 <HTML><HEAD></HEAD><BODY><P>You can use the dimensionality() function. Something like if(dimensionality()=0, avg(aggr(sum(Sales),Product)),sum(Sales)) in a pivot table that has Product as dimension and Sales as a measure for the calculations.</P></BODY></HTML> Fri, 19 Jul 2013 15:24:53 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501734#M556486 Gysbert_Wassenaar 2013-07-19T15:24:53Z Re: Can you do a different aggregate calculation in the total of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501735#M556487 <HTML><HEAD></HEAD><BODY><P>Hi Oliver,</P><P></P><P>Since the pivot table doesn't have the option to change the Total mode of the expressions in the properties dialog like the straight table, you will have to do that in your expressions. If it's just a simple average of the calculations you can achieve that using the AGGR function (advanced aggregation). For example:</P><P></P><P>avg(aggr(sum(Value),Dimension))</P><P></P><P>Please let me know if you need more information,</P><P></P><P>Cesar</P></BODY></HTML> Fri, 19 Jul 2013 15:34:34 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501735#M556487 cesaraccardi 2013-07-19T15:34:34Z Re: Can you do a  different aggregate calculation in the total  of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501736#M556488 <HTML><HEAD></HEAD><BODY><P>Thanks for your suggestion</P><P></P><P>my calc is a little different</P><P></P><P>=if (RegMonth =ActivityPeriod30,200,sum(Rev))</P><P></P><P>the resulting sum&nbsp; will always be the else condition .</P><P>Should the if condition be in&nbsp; set analysis . How would the calculation be written?</P></BODY></HTML> Tue, 08 Oct 2013 16:47:41 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501736#M556488 2013-10-08T16:47:41Z Re: Can you do a  different aggregate calculation in the total  of a pivot table . https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501737#M556489 <HTML><HEAD></HEAD><BODY><P>select COUNT (*) ,MONTH(c.created_at)&nbsp; </P><P>from tbStageF_content&nbsp; (nolock) c</P><P>where </P><P>creator_source=100</P><P>and&nbsp; year(c.created_at) =2013</P><P>and MONTH(c.created_at) &gt;= 1</P><P>group by</P><P>MONTH(c.created_at)</P><P>order by 2</P></BODY></HTML> Tue, 08 Oct 2013 17:41:47 GMT https://community.qlik.com/t5/QlikView/Can-you-do-a-different-aggregate-calculation-in-the-total-of-a/m-p/501737#M556489 2013-10-08T17:41:47Z