topic Pivot table aggregation issue. in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492418#M184161 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="47882" alt="Screen Shot 2013-10-18 at 2.17.56 PM.png" class="jive-image" src="/legacyfs/online/47882_Screen Shot 2013-10-18 at 2.17.56 PM.png" style="width: 620px; height: 335px;" /></P><P>My report looks like this. it is pivot table chart..</P><P>The first 3 columns are dimensions and last column is sum(amount) expression.</P><P>I need to change the way 3rd column looks like.</P><P>The customer "Natiello Ernesto:Kitchen" has 3 invoices with item "Cabinets:Cabinet Pulls" but this report has aggregated the amount for all 3 invoices for this customer and shown as one row.</P><P></P><P>Is there any way I can show</P><P></P><P>Cabinets:Cabinet Pulls</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.00</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 227.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P></BODY></HTML> Fri, 18 Oct 2013 21:31:22 GMT 2013-10-18T21:31:22Z Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492418#M184161 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="47882" alt="Screen Shot 2013-10-18 at 2.17.56 PM.png" class="jive-image" src="/legacyfs/online/47882_Screen Shot 2013-10-18 at 2.17.56 PM.png" style="width: 620px; height: 335px;" /></P><P>My report looks like this. it is pivot table chart..</P><P>The first 3 columns are dimensions and last column is sum(amount) expression.</P><P>I need to change the way 3rd column looks like.</P><P>The customer "Natiello Ernesto:Kitchen" has 3 invoices with item "Cabinets:Cabinet Pulls" but this report has aggregated the amount for all 3 invoices for this customer and shown as one row.</P><P></P><P>Is there any way I can show</P><P></P><P>Cabinets:Cabinet Pulls</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.00</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 227.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P></BODY></HTML> Fri, 18 Oct 2013 21:31:22 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492418#M184161 2013-10-18T21:31:22Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492419#M184162 <HTML><HEAD></HEAD><BODY><P>Can you uplad the example?</P></BODY></HTML> Fri, 18 Oct 2013 21:35:01 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492419#M184162 2013-10-18T21:35:01Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492420#M184163 <HTML><HEAD></HEAD><BODY><P>Can you add Invoice number as a Dimension?</P></BODY></HTML> Fri, 18 Oct 2013 21:35:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492420#M184163 rustyfishbones 2013-10-18T21:35:04Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492421#M184164 <HTML><HEAD></HEAD><BODY><P>I can add that..</P><P>Do you think it can make a difference</P></BODY></HTML> Fri, 18 Oct 2013 21:44:55 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492421#M184164 2013-10-18T21:44:55Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492422#M184165 <HTML><HEAD></HEAD><BODY><P>I think so</P></BODY></HTML> Fri, 18 Oct 2013 21:45:26 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492422#M184165 rustyfishbones 2013-10-18T21:45:26Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492423#M184166 <HTML><HEAD></HEAD><BODY><P>Should i upload and my QVD and QVW files?</P></BODY></HTML> Fri, 18 Oct 2013 21:45:33 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492423#M184166 2013-10-18T21:45:33Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492424#M184167 <HTML><HEAD></HEAD><BODY><P>no just add a Dimension to the Chart with Invoice number, Is the Invoice number in your Data model?</P></BODY></HTML> Fri, 18 Oct 2013 21:47:35 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492424#M184167 rustyfishbones 2013-10-18T21:47:35Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492425#M184168 <HTML><HEAD></HEAD><BODY><P>The qvw its ok(:</P></BODY></HTML> Fri, 18 Oct 2013 21:48:25 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492425#M184168 2013-10-18T21:48:25Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492426#M184169 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screen Shot 2013-10-18 at 2.48.33 PM.png" class="jive-image" src="/legacyfs/online/47884_Screen Shot 2013-10-18 at 2.48.33 PM.png" style="width: 620px; height: 352px;" /></P><P>It looks like this and subtotal appears at invoice number level which is not want i want.</P><P>I want it look like this</P><P></P><P>Cabinets:Cabinet Pulls</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.00</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Castillo, Eloisa:Utility Room&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 227.80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natiello Ernesto:Kitchen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.91</P></BODY></HTML> Fri, 18 Oct 2013 21:50:16 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492426#M184169 2013-10-18T21:50:16Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492427#M184170 <HTML><HEAD></HEAD><BODY><P>yes, that's what i added "RefNumber"</P><P></P><P>what do you mean by "just add a dimension"?</P><P></P><P>Should i remove other dimensions?</P></BODY></HTML> Fri, 18 Oct 2013 21:53:21 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492427#M184170 2013-10-18T21:53:21Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492428#M184171 <HTML><HEAD></HEAD><BODY><P>I attached the QVW file.</P></BODY></HTML> Fri, 18 Oct 2013 23:27:42 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492428#M184171 2013-10-18T23:27:42Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492429#M184172 <HTML><HEAD></HEAD><BODY><P>I cant view your file on my machine so I'm trying to guess the solution.</P><P>Do not use the aggregation sum() in the formula! Or use an extra dimension such as [Invoice date] before the expression column. Try one of them, I think it will work. Thanks</P></BODY></HTML> Fri, 18 Oct 2013 23:53:24 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492429#M184172 Anonymous 2013-10-18T23:53:24Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492430#M184173 <HTML><HEAD></HEAD><BODY><P>If i do not use aggregation sum () then my pivot table comes up empty.</P><P>If I use date then date will be grouped like CustomerFullName ...right?</P></BODY></HTML> Fri, 18 Oct 2013 23:56:29 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492430#M184173 2013-10-18T23:56:29Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492431#M184174 <HTML><HEAD></HEAD><BODY><P>If you Tried that then maybe this is not working. Try to upload the file and it will be easier to help you.</P></BODY></HTML> Sat, 19 Oct 2013 00:01:18 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492431#M184174 Anonymous 2013-10-19T00:01:18Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492432#M184175 <HTML><HEAD></HEAD><BODY><P>I uploaded the time but it seems you are not able to open it.</P><P>I am not sure how to help it.</P><P>Do you have nay suggestion?</P></BODY></HTML> Sat, 19 Oct 2013 00:03:21 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492432#M184175 2013-10-19T00:03:21Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492433#M184176 <HTML><HEAD></HEAD><BODY><P>For some reason, I cannot identify the issue. May be you need to reload your application and save it them upload it again.</P></BODY></HTML> Sat, 19 Oct 2013 00:06:56 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492433#M184176 Anonymous 2013-10-19T00:06:56Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492434#M184177 <HTML><HEAD></HEAD><BODY><P>I again uploaded it</P></BODY></HTML> Sat, 19 Oct 2013 00:11:26 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492434#M184177 2013-10-19T00:11:26Z Re: Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492435#M184178 <HTML><HEAD></HEAD><BODY><P>Your application is working fine I created a normal table to check the transactions without making aggregation but I found only one record for:</P><P>Cabinets - Cabinet Pulls - Castillo, Eloisa:Utility Room. only one record for the amount of 227.80</P><P>I also checked the table and its recorded once.</P><P>you can also go back to your datasource and find out if this is correct or not</P><P>I uploaded the file to you. Thanks</P></BODY></HTML> Sat, 19 Oct 2013 01:00:11 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492435#M184178 Anonymous 2013-10-19T01:00:11Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492436#M184179 <HTML><HEAD></HEAD><BODY><P>Hi Ramya,</P><P>Hope this&nbsp; helps you</P><P></P><P></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">regards</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><STRONG>Premhas</STRONG></SPAN></P></BODY></HTML> Sun, 20 Oct 2013 06:54:11 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492436#M184179 preminqlik 2013-10-20T06:54:11Z Re: Pivot table aggregation issue. https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492437#M184180 <HTML><HEAD></HEAD><BODY><P>I can upload the file again because <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Cabinets - Cabinet Pulls</SPAN> item has many customers.</P></BODY></HTML> Sun, 20 Oct 2013 22:46:37 GMT https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492437#M184180 2013-10-20T22:46:37Z