Forum Discussion
Working with Matrix with different levels..
hello gomezc73
something like this?
however, there are couple blank row because some rows only have value up to Level 2.
i am not sure but to create a matrix as your screenshot seem not possible at this moment.
there are levels that dont have value, for example, there are three level in Sales while there are only one level in Accounting.
So you would have a blank value in Accounting if you added until level 3 in row matrix to show value in Sale.
Visual filter seems not work as well because your blank value are placed differently in level.
Thank you.
- clear183 / 5.000
Resultados de traducción
Resultado de traducción
Exactly, that's the same result I am getting, and that's why I asked if any experts know a trick to prevent those blank levels from appearing. Thanks for the clarification.
hello gomezc73
it should be possible using bookmark or drillthrough (although it need some reworks to do).
here i create a simple example using bookmark.
Hope this will help.
Thank you.
Hi,
Thank you for your early response.
Is not possible to have a matrix to show the data in this way?
hello gomezc73
something like this?
however, there are couple blank row because some rows only have value up to Level 2.
i am not sure but to create a matrix as your screenshot seem not possible at this moment.
there are levels that dont have value, for example, there are three level in Sales while there are only one level in Accounting.
So you would have a blank value in Accounting if you added until level 3 in row matrix to show value in Sale.
Visual filter seems not work as well because your blank value are placed differently in level.
Thank you.
- clear183 / 5.000
Resultados de traducción
Resultado de traducción
Exactly, that's the same result I am getting, and that's why I asked if any experts know a trick to prevent those blank levels from appearing. Thanks for the clarification.