Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

Hide repeated text in CV excel

Source: OneStream Champions

 

Hi, is there a way to hide/format these repeated text in CV excel settings? I would like for e.g. “ProSolutions” to show once for every stats section.

 

 

image.png444×661 8.47 KB

 

Thank you!

3 Replies

  • RachealCrowder's avatar
    RachealCrowder
    New Contributor III

    I recently asked a very similar question to OneStream on behalf of a client and received the following suggestion that may or may not work for you:

    1. Apply a conditional formatting to the row header (‘Gold’ is the member name of the first item in row expansion 2 in my report)

       

    2. The cube view in data explorer (you can see gold is the first member):

       

    3. Run to excel – you can see these items are white:

       

    Given there isn’t a true way to suppress the headers, I would encourage you to submit an enhancement request on this topic.

  • BobMarchese's avatar
    BobMarchese
    New Contributor III

    You may also find the color “transparent” to be more universal. I’ve had success using that to hide text, and it doesn’t care what color it’s up against.