topic Re: Pivot table aggregation question in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288221#M497575 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have to use Sum(Distinct Value) to show that value you are asking for like</P><P></P><P>132 + 78 = 210</P><P></P><P>And use pivot table to show this type of data representation.</P><P></P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Sat, 24 Sep 2011 19:31:13 GMT its_anandrjs 2011-09-24T19:31:13Z Pivot table aggregation question https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288219#M497573 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Probably a simple question. </P><P>The below excel example show what I want to do.</P><P></P><P>All CostComponentFrom has the same value. I only want this single value to be summed when I collapse the dimensions in the pivot table.</P><P></P><P><IMG src="https://community.qlik.com/" /></P></BODY></HTML> Sat, 24 Sep 2011 18:37:06 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288219#M497573 2011-09-24T18:37:06Z Re: Pivot table aggregation question https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288220#M497574 <HTML><HEAD></HEAD><BODY><P>Here is the excel sheet showing what I am trying to do.</P></BODY></HTML> Sat, 24 Sep 2011 18:39:21 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288220#M497574 2011-09-24T18:39:21Z Re: Pivot table aggregation question https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288221#M497575 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have to use Sum(Distinct Value) to show that value you are asking for like</P><P></P><P>132 + 78 = 210</P><P></P><P>And use pivot table to show this type of data representation.</P><P></P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Sat, 24 Sep 2011 19:31:13 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288221#M497575 its_anandrjs 2011-09-24T19:31:13Z Re: Pivot table aggregation question https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288222#M497576 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Might be it is your solution</P><P>See the attached sample file Hope this may be help you.</P><P></P><P>Let me know about this.</P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Sat, 24 Sep 2011 19:40:06 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-question/m-p/288222#M497576 its_anandrjs 2011-09-24T19:40:06Z