JacobH
2 years agoNew Contributor II
Want to stop entity name from repeating in a cube view
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!
At the end of the member filter you can use :Name(" ") to insert a space as the name.