Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to switch column categories when switching between categories in filter?

Dear Community 🙂

I have created a matrix table with a slicer on a variable called 'Segment', which can either take on 'Product Tankers' or 'Crude Tankes'

My problem is that when 'Segment'='Product Tankers' I need one set of column names (from a column called 'Product Segment') and when 'Segment'='Crude Tankers' I need a different set of column names (from a column called 'Crude Segment') to be displayed in the matrix. 

Can anyone help me to link different column names to the categories in a slicer?

So that when I choose 'Product Tankers' from the segment filter I get column names from the variable 'product_segment' and when I choose 'Crude Tankers' from the segment filter i get column names from the variable 'crude_segments'.


I have attached pictures to describe my problem:


So when I choose ' Products Tankers' it works correct:

But when I choose 'Crude tankers' the column names are wrong as they refers to product_segment:

Instead I need this when I choose 'Crude Tankers':




Thanks in advance 🙂 


2 Replies