Hiding columns in a matrix based on a filter

[Raymo3u99]

I have a table with the following columns

Region

Category

Org_comment

Region_comment

Cat_comment

Eff_month

Variance_amt

I have a filter where the user selects the type of comment to display : Org / Region / Cat

I need to display the following in a matrix: ( The comment column should show either org_comment, region_comment or Cat_comment based on user selection)

Region Category and Comment are the rows

 Eff_Month is the column and

Variance_amt is the value

Region	Category	Comment	Eff Month

Thanks for your help.

Raymond

[amitchandak]

@Raymo3u99 , see if that can help

https://www.youtube.com/watch?v=6jeSIRpjv0M

[Raymo3u99]

Thanks @amitchandak .

That worked for me. The only issue I found was that it dropped null values from the unpivoted column, so I had to create a view and replace nulls with blanks.

[v-lionel-msft]

Hi @Raymo3u99 ,

"That worked for me. The only issue I found was that it dropped null values from the unpivoted column, so I had to create a view and replace nulls with blanks."

Please show a sample data table, maybe I can help you complete the table conversion work.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.