I have a Date(30.06.2009) set as a Variable(vDate) and assigned to a calenderobject. I want to use this variable in the Expression of a chart. if there are other fields like BegDate with 2 input fields =2005-01-01,2009-01-01 and EndDate with 2 input fields as 9999-12-31,2008-12-31
For ex:- If(vDate >=BegDate and vDate <=EndDate, cond1, cond2)
it must select the fields BegDate=2009-0-01 and EndDate=9999-12-31 and give the cond1 correctly
OK, perhaps sum is not applicable, I used it only as an example. It's just that you should have an aggregat function in a pivot table expression; perhaps min or max or firststring could work.
Vielendank it works