it is possible to attach fack data?
I will make and attach.
Attached is the mock up.
We need to create a parameter based on Column 'Frequency'.
Then we need to create a calculated field using this parameter.
It will be like this.
If Parameter = Monthly, then month to date
If Parameter = Quarterly, then Quarter to Date
If Parameter = Yearly, then Year to date.
Once we will make calculated field, we will put this field on filter self. After this, based on user selection of monthly, quarterly and yearly, data will be populated.
We are using SQL Server 2014 as database.
We cannot provide date in filter because we are using some run time calculations (LOD Expressions) and we want to show data based on parameter selection and then other graphs will be populated based on first selection.
How to attach xls file?