Date Problem when inputbox used

[renjithpl]

Hi All,

My table:

Date	Infringement Analysis	Invalidity Analysis	Foreign Language	QC Complete	Information
25-Aug	0	0	2	0	51
26-Aug	11	0	20	21	749
27-Aug	7	1	107	31	1164
30-Aug	52	37	248	80	3687
31-Aug	96	49	396	271	5927

I used cross table to bring the above table information in my application. Like this

IssueCategory:

CrossTable(IssueCategory, Number, 2)

LOAD * FROM

[QC Log\Assignment Tracker.xls]

(biff, embedded labels, table is [Issue Category$]);

In my application, I have a input box where I have a variable called "EnterDate" and my formula is =today() in that variable. But my project ended on 31-Aug. I actually want to bring 31-Aug information on a pivot table.

So I am trying something like this in my pivot table expression =Sum (if(Date<=EnterDate AND IssueCategory='Information',Number))

But its giving Total of all the "information" .

I want only 5927.

Please help.

[#2]

if you want only 5927, it should be something like this:

sum( if( Date = Max(Date) And IssueCategory = 'Information', Number)).

this can also be done with Set Analysis...

Kind regards,

Miha