Crosstab hide rows with null values and hide title column measures

Question

Hi.

I have a crosstab where I would like to hide the column with the titles of the measures, and also some rows that don't return results (rows with null values).

This is the cross table

This is her structure

Thanks

Answer 1

Hello,

1) the columns with measure title cannot be hidden, but you can rename them

2) null rows can be hidden, but this functionality is available only when measures are set on columns



Bye,
Marco

Comments

Hello Marco.

Thanks for answering my question.
I understood how crosstab works.
I regret that I won't be able to model it exactly as I would like, hiding the column with measure titles and the rows with null values, however the data presentation is as I need, with the measures in the lines because it is better to read that way.

I leave here my suggestion for improvement, if it is possible to implement these two options for a future version.

Thanks,
Alessandro

---

We will for sure consider these improvements in the next releases of KNOWAGE.
If you found the answer useful, please vote it as best answer so that other users will see it first if they need it!

Thank you!