Skip to main content
Newcomer
May 24, 2023

Reduce the size of empty row

  • May 24, 2023
  • 3 replies
  • 0 views

Dear community, we have requirement to reduce the size of empty row, do we have any solutions to this. Any solutions to this question will be very helpful.

Thank You!

3 replies

Veteran
May 24, 2023

Hey Ranvir06 !
Have a look at the row data settings in your cube view.
Please use the suppress option with care as it might impact the performance of your cube view.

NicolasArgente_0-1684937475501.png
Please give a kudo if it helps.

 

Contributor
May 24, 2023

you might be using same member name for all empty rows (ex: A#None), if that is the case, I would try applying cell format on the row with condition like below

if RowE1memberName = None Then "Select your formatting" End If

If above logic works, create a literal parameter and paste that code in the parameter value.

Where ever you need that formatting for empty rows just use that parameter in cell format. 

Regards

Sridhar 

Contributor
January 8, 2024

Dear all,

Do you have an idea to answer to the original question about the row size?

Thank you. BR