selection conflict.

[arusanah]

I Have two reports in same document.

i standard pivot table and other is dynamic  report .

for dynamic report i created two calander objects ( fromDate & toDate) . what is happening now is my calendar object overrides my selections for standard report which are based on  Year & month dimension.

how can i resolve it ?

[maxgro]

I think you have to disregard the selection on the field used in calendar, a date?

if the field is date, try to add a date=

sum( {$<date = >} Sales )

returns the sales for the current selection, but with the selection in “date” removed.

[Anonymous]

Hi,

Its a common problem, Actually you need to load stand alone columns (tables) for calender objects that means these tables should not join with any other tables.

Just do a resident load for date column which you want to use inin calendar object and give them different column name.

Thanks

BKC