Want to stop entity name from repeating in a cube view

[JacobH]

Hi all -

I am trying to format a cubeview a specific way.

Then the rows are like follows:

Entity1 Title row

Entity1 net sales

Entity1 Profit

Entity1 Margin %

Blank row for spacing

Entity2 Title row

Entity2 net sales

Entity2 Profit

Entity2 Margin %

Blank row for spacing

This continues on for a bit in the exact layout. What I want to do is hide the entity name in all the rows except for the title row. Then in the blank rows I am currently seeing "none", I would like that to be gone as well.

What is the best way to stop the entity name from repeating and removing the word "none" from my blank spacing rows?

TIA!

[EricOsmanski · Accepted solution]

At the end of the member filter you can use :Name(" ") to insert a space as the name.