
1. Re: Changing field(dimension) values dynamically using parameters.
Joe Oppelt Feb 6, 2019 12:25 PM (in response to Ramesh N)Are you looking to filter your rows so that if the user selects "Jan" in the parameter, then you only want to see "Actual" rows, for example?
If so, the you want to do:
IF Current_Quarter = "Jan" AND Category = "Actual" then 1
ELSEIF Current_Quarter = "Apr" AND Category = "Budget" then 1
ELSEIF Category = "Forecast" then 1
END
(And all other conditions default to NULL).
Put that on the filters shelf and select for value = 1. 
2. Re: Changing field(dimension) values dynamically using parameters.
Michael Hesser Feb 6, 2019 12:38 PM (in response to Ramesh N)1 of 1 people found this helpfulHi Ramesh;
I don't think you need to refer to [Category] within the equations.
For Example:
Calc_Category
IF Current_Quarter = "Jan" THEN "Actual"
ELSEIF Current_Quarter = "Apr" THEN "Budget"
ELSE "Forecast" END
Here Calc_Category will take on one of three values. In your filters, make sure [Category] = Calc_Category. You can also make a simple T/F calc ([Category]=[Calc_Category]) and drop that into the filters.
Your others can be simplified to:
Calc_Prev_Year
STR(FLOAT([Current_Year])1)
Calc_Next_Year
STR(FLOAT([Current_Year])+1)
These convert the year to number, then subtract or add a year.
Hope this helps!

3. Re: Changing field(dimension) values dynamically using parameters.
Ramesh N Feb 6, 2019 12:43 PM (in response to Joe Oppelt)Hi Joe,
Thanks for the quick response!
I need to change the values of Category & Year based on the selection of Parameters because I have to use those 2 calc_fields in LOD.
attr({exclude [Year]:sum(if [Year] = [Calc_Prev_year] AND [Category] = [Calc_Category] then [Sales] else 0 end)})
Is it possible to get this?
Thanks in advance,
Ramesh

4. Re: Changing field(dimension) values dynamically using parameters.
Joe Oppelt Feb 6, 2019 12:45 PM (in response to Ramesh N)You can't change data values in data source fields.
You make a second field (your calc field) and set values there, and use that new calc field moving forward. So you want to follow what Michael suggested.

5. Re: Changing field(dimension) values dynamically using parameters.
Ramesh N Feb 6, 2019 1:06 PM (in response to Michael Hesser)Thanks so much Michael!
Calc_Category
IF Current_Quarter = "Jan" THEN "Actual"
ELSEIF Current_Quarter = "Apr" THEN "Budget"
ELSE "Forecast" END
This worked