topic Re: Pivot table aggregation issue. in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-aggregation-issue/m-p/492438#M184181 <HTML><HEAD></HEAD><BODY><P>Hi Premhas,</P><P>Thanks for the qvw file. I have two questions though.</P><P>1. I saw that you have added " new_dimension". Does it mean we have to have one extra dimension between our expression and the original dimension (here it is CustomerFullname) to expand this original dimension to its maximum i.e. all occurrence of all customers? </P><P>we can not have the below mentioned layout without bringing an extra dimension between Customer name and sum(amount)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Cabinets:Cabinet Pulls</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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><P>2. What is the difference between expression "sum(amount)" and "=sum(amount)".</P></BODY></HTML> Sun, 20 Oct 2013 22:52:35 GMT 2013-10-20T22:52:35Z 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