https://community.qlik.com/t5/QlikView/Pivot-table-The-calculation-changes-when-moving-the-dimension-to/m-p/1684596#M506562 <P>Hi there,</P><P>&nbsp;</P><P>I created a pivot table with one dimension and one expression and by default, everything looks good. But when I relocate the dimension to the top of the table so I can have a different view, the calculation just changes. Why is this happening ?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Default" style="width: 249px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30028i14B63BDAD240C9AC/image-size/large?v=v2&amp;px=999" role="button" title="Captura1.PNG" alt="Default" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Default</span></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dimension on top" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30029i8723C96FD97E0497/image-size/large?v=v2&amp;px=999" role="button" title="Captura2.PNG" alt="Dimension on top" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Dimension on top</span></span></P><P>&nbsp;</P><P>Best regards</P><P>&nbsp;</P> Fri, 13 Mar 2020 18:51:24 GMT digichap28 2020-03-13T18:51:24Z https://community.qlik.com/t5/QlikView/Pivot-table-The-calculation-changes-when-moving-the-dimension-to/m-p/1684596#M506562 <P>Hi there,</P><P>&nbsp;</P><P>I created a pivot table with one dimension and one expression and by default, everything looks good. But when I relocate the dimension to the top of the table so I can have a different view, the calculation just changes. Why is this happening ?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Default" style="width: 249px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30028i14B63BDAD240C9AC/image-size/large?v=v2&amp;px=999" role="button" title="Captura1.PNG" alt="Default" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Default</span></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dimension on top" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30029i8723C96FD97E0497/image-size/large?v=v2&amp;px=999" role="button" title="Captura2.PNG" alt="Dimension on top" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Dimension on top</span></span></P><P>&nbsp;</P><P>Best regards</P><P>&nbsp;</P> Fri, 13 Mar 2020 18:51:24 GMT https://community.qlik.com/t5/QlikView/Pivot-table-The-calculation-changes-when-moving-the-dimension-to/m-p/1684596#M506562 digichap28 2020-03-13T18:51:24Z https://community.qlik.com/t5/QlikView/Pivot-table-The-calculation-changes-when-moving-the-dimension-to/m-p/1684643#M506563 <P>Never mind. I changed it to a straight table and set the presentation to horizontal. Solved!</P> Fri, 13 Mar 2020 22:00:08 GMT https://community.qlik.com/t5/QlikView/Pivot-table-The-calculation-changes-when-moving-the-dimension-to/m-p/1684643#M506563 digichap28 2020-03-13T22:00:08Z