Forum Discussion
Denis_Slav
4 years agoHelper III
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 | |||
| Channel | Spots per block AVG | Spots per block MAX | Spots per block AVG | Spots per block MAX |
| ABC | 123 | 123 | 123 | 123 |
I'd like to change view to:
| Spots per block | ||||
| AVG | MAX | |||
| Channel | 2020 | 2021 | 2020 | 2021 |
| ABC | 123 | 123 | 123 | 123 |
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
- Denis_SlavHelper III
Thanks. Yes, it looks what I need! Go to analyze, how to adopt it for my task. )
- PaulDBrownCommunity Champion
Does the header structure have to be dynamic? if , so, under which cirteria?
- Denis_SlavHelper III
No, in this case it should be fixed. But if it possible to create dynamical, it may be usefull for future.