I’ve got a calculated field returning a string and have a parameter for it. In the value names it lets me use the parameter and it changes the column heading, but it gives me the value “All” which is not correct. I want it to return the value I placed in the string in the calculated field.
Are you changing the parameter?
It will only change when you change the parameter.
You can do that with a control. You cannot change the parameter with a calculated field.
I have the parameter pointed to a column of data with the value I want to display. All of the rows have the same value which kind of explains the All, but that is not what I want. My goal is have the column header by something like
Jan 2022
Feb 20222
The dynamic date option doesn’t work, because it has to be based upon what data is in my system, not the system date.
I’m sorry, so you’re saying something like this won’t work because you don’t have all of the dates in your dataset?
The date as a pivot column, as you suggest is a great idea that I tried. However, I get stuck on calculating the change from the prior month & percentage change from prior month.
– PriorMonth as calculated field
sum(if else(dateDiff(MyPivotDate,AsOfDate,“MM”) = 1, 0) /* comes up with zeros which is wrong */
– AsOfDate as calculated field
maxOver(MyPivotDate, , PRE_ARG)