Cubeviews - Add blanks between Member expansions
Hello,
I hope you're all doing well, this is my first time posting in the forum.
I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.
In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.
Thanks in advance, wishing you all a blessed day
Not that I'm aware. You could maybe do it in actual reports, with Cube View Extenders, but not in Excel as far as I'm aware. The best i can think of is writing custom member list with some dummy "blank" member, then have a conditional format that will paint them "white on white" - but again, chances are it doesn't work when exported to Excel.
Obviously it works if you simply create multiple rows, one for each entity, and put blank rows inbetween.
