https://community.qlik.com/t5/App-Development/Pivot-Table-Calculated-Dimension-Total/m-p/1781619#M60823 <P>Dear All,</P><P>Looking for a Total for calculated dimension in Pivot table.</P><P>Basically I have 3 measures (Vol,%XYZ,%ABC) and 2 dimensions (Category,MonthYear).</P><P>I want to split %XYZ and %ABC by MonthYear (Second dimension); However first measure (Vol) should not get splited by MonthYear, so my instinct asked me to place it under Calculated dimension. However Total for the calculated dimension not visible and even wrapping aggr expression with Sum shows invalid row error.</P><P>Please suggest how can I achieve this either with the same manner or any other technique please.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="prob statement.png" style="width: 792px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48846i43992D004323E9BF/image-dimensions/792x202?v=v2" width="792" height="202" role="button" title="prob statement.png" alt="prob statement.png" /></span></P> Wed, 10 Feb 2021 12:01:48 GMT brijesh1991 2021-02-10T12:01:48Z https://community.qlik.com/t5/App-Development/Pivot-Table-Calculated-Dimension-Total/m-p/1781619#M60823 <P>Dear All,</P><P>Looking for a Total for calculated dimension in Pivot table.</P><P>Basically I have 3 measures (Vol,%XYZ,%ABC) and 2 dimensions (Category,MonthYear).</P><P>I want to split %XYZ and %ABC by MonthYear (Second dimension); However first measure (Vol) should not get splited by MonthYear, so my instinct asked me to place it under Calculated dimension. However Total for the calculated dimension not visible and even wrapping aggr expression with Sum shows invalid row error.</P><P>Please suggest how can I achieve this either with the same manner or any other technique please.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="prob statement.png" style="width: 792px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48846i43992D004323E9BF/image-dimensions/792x202?v=v2" width="792" height="202" role="button" title="prob statement.png" alt="prob statement.png" /></span></P> Wed, 10 Feb 2021 12:01:48 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Calculated-Dimension-Total/m-p/1781619#M60823 brijesh1991 2021-02-10T12:01:48Z