Hi,
My. Requirement is:
-
While loading report must show last 60 days data. after that user can choose date range max of 60 days different (I am using custom filter for UI).
-
My filter on main report is : (A and B and C) OR A AND D (Where A is product from custom filter , B start date from custom filter, C end date from Custom filter, D is report filter = less than 60 days)
-
I am getting last 60 days data while loading report and getting data base on custom filter if user change date range.
-
I have drill down report which also show correct data.
-
Issue is when i apply column menu summarize on drill down report its showing result on default report data not on customer date range data.