Can you please explain further what you want it to do? You have a month field in the data - how does this date parameter relate to that - or should I say how do you want it to relate? i.e. you select a date and what should happen?
Many thanks for getting back to me
I have couple of views in my report.
Sheet1: All the calculations and the filter used is [Month]
Sheet2: Calculated a Rolling sum and the parameter used it [date]-----(Range of Values are set from "Set from fields[Month])
Now my actual problem is i need to create a dashboard and in the dashboard i don't want to use 2 filters which is very confusing to the user.I just want to give one date control.
The following is the approach i tried..
Sync the [date] parameter with [month] dimension ...unfortunately it didn't work.It's showing me an error.
Please find the screen shot attached.
Also please find the updated workbook attached.And Many thanks for all the support!!
Rolling sum.twbx 42.7 KB
1 of 1 people found this helpful
Create a calculated field with the following formula: DATETRUNC('month',[Date]) = DATETRUNC('month',[Month])
Put that on the filter shelf of your 'Total' sheet and set to True. Then your parameter works for both sheets.