It's a difficult problem for me !!!!!!!!!!!!!!!!!!!

[#1]

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.

[#2]

NO,

Sorry, this is not my question.

I want the result as i explained in the example!

[#3]

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?

[#4]

Hi, i think this is what you need.

Hope it helps

[#5]

Thanks alot freind.

This is the exact thing that helps me.