topic Pivot table report in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173152#M42446 <HTML><HEAD></HEAD><BODY><P>This is my offer, Luis</P></BODY></HTML> Wed, 25 Aug 2010 10:24:29 GMT llauses243 2010-08-25T10:24:29Z Pivot table report https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173150#M42444 <HTML><HEAD></HEAD><BODY><P>Hi friends! This is my first time in Qlikview Forum, so I am glad of being in the Qlikview family. I have a question as below:</P><P>I have a table of Sales as following:</P><P>Branch date Sales NO_OF_New_Customers</P><P>1 1/1/10 100,000 2</P><P>1 1/2/10 120,000 3</P><P>2 1/1/10 200,000 4</P><P>2 1/2/10 150,000 1</P><P>I want to have a pivot table that shows the total sales of a branch from the begining to a specific date (the date can be selected by user from a list box), but the number of new customers of that specific date (No Sum) like this:</P><P>Branch date Sales NO_OF_New_Customers</P><P>1 1/2/10 220,000 3</P><P>2 1/2/10 350,000 1</P><P>How can I have this Repot?</P><P>Thank you very much in advanced.</P></BODY></HTML> Wed, 25 Aug 2010 07:42:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173150#M42444 2010-08-25T07:42:54Z Pivot table report https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173151#M42445 <HTML><HEAD></HEAD><BODY><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0045.dimension-w-if.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/0045.dimension-w-if.bmp" /></A></P></BODY></HTML> Wed, 25 Aug 2010 10:04:42 GMT https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173151#M42445 llauses243 2010-08-25T10:04:42Z Pivot table report https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173152#M42446 <HTML><HEAD></HEAD><BODY><P>This is my offer, Luis</P></BODY></HTML> Wed, 25 Aug 2010 10:24:29 GMT https://community.qlik.com/t5/QlikView/Pivot-table-report/m-p/173152#M42446 llauses243 2010-08-25T10:24:29Z