i want to show total weekly data(7 days) and monthly data(30 days) in a one list report.
data is shown by the count of one column.
is there any way to apply filter for the same data item which will be showing monthly in one column and weekly in the other column.
or is there any way to write expression to write in both the columns.
You cannot perform this action by applying a filter. You need to use CASE expressions that will return the value for a given daterange (month,week) or else 0:
CASE WHEN
EXTRACT(MONTH,[somedate]) = ................
THEN ([some_measure])
ELSE (0)
END
And use this expression on a specific data-item..