Forum Discussion

Ranvir06's avatar
Ranvir06
New Contributor II
2 years ago

Reduce the size of empty row

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

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor

    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.


    Please give a kudo if it helps.

     

  • 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 

  • Dear all,

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

    Thank you. BR