Joe can you please explain a bit more on why window_max and attr of the dimension will keep all fields showing? i tried it and worked great, i even did across and down with 2 different fields, basically locked both columns and rows, but I am still fuzzy with the mechanics behind it. Thanks again for this wonderful solution.
I have a similar issue, I have a data source that includes all students grade for a particular year, I passing with a filter a student that is not on that data source and getting "none" as a result, I would like to replace this with "n/a", tried different routes none are working. Any suggestions
if [grade] = "" then "n/a" else [grade] end
if isnull([grade]) then "n/a" else [grade] end
ifnull ([grade], "n/a")