set analysis problems

[#1]

Hi i have a pivot table and I am trying to calculate how many products of one brand i have in stock. ok...i can set a timerange for this with a slide bar. what I have selected is the 21.10.2012-18.11.2012.

and my chart looks like this:

brand     1.stock                   1.Date               LastDate

asdf          452                      21.10.2012     18.11.2012

aqwe        0                           28.10.2012     18.11.2012

so for the brand aqwe I dont want the 0 to be shown I want the 1.stock from the 28.10.2012 to be shown. so my expression looks like this: sum({<#Date = {'$(=min(#Date))'}>}#Stock). why does aqwe shows a first stock even though on the 28.10.2012 i had a stock from 770??? if is obviously using the 21.10.2012 as min(#Date) in set analysis. Can someone help me to fix this problem?????

regards,

MT

[#2]

oh and i forgot the expression for 1.Date is min(#Date) and for LastDate it is max(#Date)

[#3]

Hi

Can u post a sample file?

TMF

[#4]

sry I can't these are sensitiv data I'm using

[#5]

I understand...

You can post a sample file with few records (create a new DB with few records) just for try to help you, if you want.

TMF

[#6]

I finally got the time to create some sample data

regards,

MT

[#7]

can someone please help me with this problem! Im not able to find a solution by myself...any kind of help is appriciated.

regards,

MT

[#8]

can still no one tell me how to solve this?