Keep a row when drilling-up in matrix

[Anonymous]

Hi all,

I have created the following matrix, with different aggregations of records. This works well and is giving the expected result.

The problem with this first approach is that, if I'll drill up to the first level, I cannot see the data grouped by "luseName", which is my objective.

What I'd like is that, when I drill up, I still can see "luseName" as a field that's grouping the values. The structure would look like this:

So, each time I drill up and down, I'd like to keep "luseName" filtering whatever is drilled up or down. The problem with the approach in the second picture is that I've used "luseName" as a value in the matrix. Because of this, only a summary of "luseName" is shown (first, min, max, etc.)  Is there a way of achieving the intended result, while displaying each row by "luseName"?

Thank you!

[lbendlin]

Any reason why you cannot use "luseName"  as a visual level filter?

[Anonymous]

You mean, something like having it like this?

I think that changes the original idea. What I'm looking for is to be able to see the area and khsm of land use at different levels of aggregation

[lbendlin]

Read about the "Personalize Visuals" function. That will give your report users the flexibility to change the matrix components around, and to keep the land use field expanded.