Forum Discussion

Denis_Slav's avatar
Denis_Slav
Helper III
4 years ago
Solved

Matrix with Hierarchical column header

Hi All, 

How can I create hierarchical headers in matrix? 

For example, I've got the current view:

 2020 2021 
ChannelSpots per block AVGSpots per block MAXSpots per block AVGSpots per block MAX
ABC123123123123

I'd like to change view to:

 Spots per block   
 AVG MAX 
Channel2020202120202021
ABC123123123123

Where [Spots per block AVG] & [Spots per block MAX] it's measures. 

I know, that I could move measures to rows, but I need exact hierarchical in columns headers.

4 Replies