topic Displaying total as a line item in QlikView https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022333#M933386 <HTML><HEAD></HEAD><BODY><P>I want to only show the total of each unit of data, for the current month and the prior month, on my dashboard with the ability for the user to drill down to see the individual line items.&nbsp; </P><P></P><P>How is this be done using QlikView?</P><P></P><P>Thank you in advance. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Displaying total as a line item https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022333#M933386 <HTML><HEAD></HEAD><BODY><P>I want to only show the total of each unit of data, for the current month and the prior month, on my dashboard with the ability for the user to drill down to see the individual line items.&nbsp; </P><P></P><P>How is this be done using QlikView?</P><P></P><P>Thank you in advance. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022333#M933386 2020-11-25T16:16:04Z Re: Displaying total as a line item https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022334#M933387 <HTML><HEAD></HEAD><BODY><P>You could create a drill down group to drill down from Month to Line, or just use a pivot table and collapse / expand dimension values.</P><P></P><P>See attached for both suggested solutions.</P></BODY></HTML> Mon, 07 Mar 2016 23:34:08 GMT https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022334#M933387 swuehl 2016-03-07T23:34:08Z Re: Displaying total as a line item https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022335#M933388 <HTML><HEAD></HEAD><BODY><P>Thank you. </P></BODY></HTML> Tue, 08 Mar 2016 16:39:57 GMT https://community.qlik.com/t5/QlikView/Displaying-total-as-a-line-item/m-p/1022335#M933388 2016-03-08T16:39:57Z