topic Re: Pivot table restrictions/functionality in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-restrictions-functionality/m-p/893832#M311202 <HTML><HEAD></HEAD><BODY><P>There is no standard functionality for this, however if you have a way to recognize these rows, you can use that to do some specific calculation (and/or formatting). For example, if there is a e.g.a field DimProperty you can use in your calculating expression:</P><P></P><P>if(DimProperty='Headline',If(Dimensionality()=1,MyCalcForTotal),NormalCalc)</P></BODY></HTML> Tue, 02 Jun 2015 09:24:58 GMT stigchel 2015-06-02T09:24:58Z Pivot table restrictions/functionality https://community.qlik.com/t5/QlikView/Pivot-table-restrictions-functionality/m-p/893831#M311201 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have a pivot table. Some of the rows are actually headlines and shouldn't contain any sub-dimensions. Is there a possibility to exclude these rows from pivot functionality? And give these "head line" property within the pivot?</P><P></P><P>Edit: What if I want these head lines to contain the total sums but not the sub-dimensions?</P><P></P><P>Br</P><P>Chris</P></BODY></HTML> Tue, 02 Jun 2015 09:08:58 GMT https://community.qlik.com/t5/QlikView/Pivot-table-restrictions-functionality/m-p/893831#M311201 mr_novice 2015-06-02T09:08:58Z Re: Pivot table restrictions/functionality https://community.qlik.com/t5/QlikView/Pivot-table-restrictions-functionality/m-p/893832#M311202 <HTML><HEAD></HEAD><BODY><P>There is no standard functionality for this, however if you have a way to recognize these rows, you can use that to do some specific calculation (and/or formatting). For example, if there is a e.g.a field DimProperty you can use in your calculating expression:</P><P></P><P>if(DimProperty='Headline',If(Dimensionality()=1,MyCalcForTotal),NormalCalc)</P></BODY></HTML> Tue, 02 Jun 2015 09:24:58 GMT https://community.qlik.com/t5/QlikView/Pivot-table-restrictions-functionality/m-p/893832#M311202 stigchel 2015-06-02T09:24:58Z