Remove calculations in specific columns

[glee1207]

Hi All,

I have a Matrix wherein, I have added calculations to the columns as sub-columns.

Now, I would like that the calculations don't show up in some of the columns. 

like kind of hide them. 

So in the attached screenshot, we have various heads in the columns (Applicants, Conditional, Unconditional, Accepted, FC) and then there are calculations (Cur_Yr, y-1, y-2, vs y-1% and vs y-2%).

My query is can we hide y-1, y-2 vs y-1% and vs y-2% from only Conditional, Unconditional and Accepted columns and let them show in the rest of the heads like Applicants and FCI.

Thanks and Regards

Arpit

[lbendlin]

Read about SELECTEDVALUE.  In your measure return BLANK() if you want to suppress the display in a cell. Note that this will not help you with the column headers, these will still be visible unless you disable auto size  and word wrap, and manually shrink the column width.