Forum Discussion
Solved
Filtering matrix columns with dropdown
Hello, this is not as simple as it sounds. Lets say I have data : Type Value a 5 a 20 b 15 b 10 c 15 c 30 And I want a matrix like this : Type 1 Type 2 value ...
Hi 314mp_M0th4 ,
If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi 314mp_M0th4 ,
If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! I also found that I am a dummy and by using basic filtering on page from the filtering pane you get the same result as using a dropdown.