Hi
I have 3 tables on a worksheet.
The first table is for Week - This is dependent on user selection of week.
The 2nd and 3rd table are showing details of Month to Date and Year to Date (Date of Week selected)
I am using the formula as below for month - for year I use inyeartodate
sum({1}-1*(InmonthToDate(SCSDAT,CurYearWeekEnd,0)*SCPAX))
SCSDAT - is the date field
CurYearWeekEnd is the selected value from the filter - this is a field in the table and is equivalent to weekend(SCSDAT)
SCPAX is the field I want sum of.
The weekly table gets refreshed on change of the week selection
However the 2 other tables which are for month and year don't refresh with the new selection. However if I open and edit the table and change the formula (rather re-save) then the table gets refreshed and correct values are displayed
Anyway for refreshing the other 2 tables automatically? Is there a refresh command?
Any work around would be appreciated.
Thanks
Arvind