set anaylsis (greater and less than)

[#1]

Hi i have a striaght table per below:

order date	Volume widgets	volume contacts widgets	volume contacts widgets 7 days
1/1/2011	10	11	4
2/1/2011	12	4	3
3/1/2011	3	10	10

To calculate the last field i need to know the order date, the contact date, and the differnace. the current formula looks like below

count(distinct {<contactdate={">=$(daystart((orderdate)))<=$(daystart((orderdate)+7))"}>} contact)

the issue is that this seem to calculate count(distinct contact)

additionally i have attempted a simlar version which just looks after the order date but the outcome is the same.

count({<contactdate={">$(=daystart(today()-122))"}>} contact)

look forward to your comments.

alan

[#2]

you cant do it in chart if  orderdate is your dimension

could you post a sample file here?

[chematos]

I think the syntax is like this:

count({<contactdate={' >=$(=daystart(orderdate)) <=$(=daystart(orderdate)+7)'}>} distinct contact)