Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
I have a table of Sales as following:
Branch date Sales NO_OF_New_Customers
1 1/1/10 100,000 2
1 1/2/10 120,000 3
2 1/1/10 200,000 4
2 1/2/10 150,000 1
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:
Branch date Sales NO_OF_New_Customers
1 1/2/10 220,000 3
2 1/2/10 350,000 1
How can I have this Repot?
Thank you very much in advanced.
NO,
Sorry, this is not my question.
I want the result as i explained in the example!
hehehe.... u want a table that shows the sum of no of customers that if u click on june, then it shows the total from january that year until june the same year correct?
Hi, i think this is what you need.
Hope it helps
Thanks alot freind.
This is the exact thing that helps me.