topic Pivot Table with Cyclic Dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-with-Cyclic-Dimension/m-p/28393#M4697 <HTML><HEAD></HEAD><BODY><P>I do not get the grand total when using Cyclic Dimension in Pivot table. However when I expand all, I see that they are sub totals.</P><P></P><P>How do I get the grand total on top of the table?</P></BODY></HTML> Thu, 12 Apr 2018 18:34:05 GMT Anonymous 2018-04-12T18:34:05Z Pivot Table with Cyclic Dimension https://community.qlik.com/t5/QlikView/Pivot-Table-with-Cyclic-Dimension/m-p/28393#M4697 <HTML><HEAD></HEAD><BODY><P>I do not get the grand total when using Cyclic Dimension in Pivot table. However when I expand all, I see that they are sub totals.</P><P></P><P>How do I get the grand total on top of the table?</P></BODY></HTML> Thu, 12 Apr 2018 18:34:05 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-with-Cyclic-Dimension/m-p/28393#M4697 Anonymous 2018-04-12T18:34:05Z Re: Pivot Table with Cyclic Dimension https://community.qlik.com/t5/QlikView/Pivot-Table-with-Cyclic-Dimension/m-p/28394#M4698 <HTML><HEAD></HEAD><BODY><P>Use Dimensionality() function</P></BODY></HTML> Thu, 12 Apr 2018 18:48:42 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-with-Cyclic-Dimension/m-p/28394#M4698 Qrishna 2018-04-12T18:48:42Z