Hiding a Column



Trying to build a simple report. Are you able to simply hide a column in Pyramid like you would an excel document?


For example - Where some columns pull through blank i'd like to simply hide.

6 replies

    • Let me connect you
    • Community_chris
    • 7 mths ago
    • Reported - view

    Hi Amy,
    if I understand your Question correct, it would look something like this. I built a quick report on Explore.Pyramid
    As you can see the first column shows three rows with no values.

    If I now 'focus' with a right click just on these first three values, so force Pyramid to bring back an empty row. It would not display this column, although it is still in the original report.

    To actively show this 'empty' column you would switch it on in the Query Tab and click 'Show Empties'

    Hope this answered the question

    • Amy_Christophers
    • 7 mths ago
    • Reported - view



    Thankyou for your reply. I'm unsure this answers my question, please see below screenshot. In this case I simple want to hide the column % Total Consumer Sales Inc Vat vs LY% - However just this column. Which you are unable to do without hiding all vs LY% columns it seems. This is the case when we want to hide any % column.



      • Nkhensani_Khoza
      • 7 mths ago
      • Reported - view

      Hey   , I hope you are well! 

      I have this below image and I want to hide Expense of 2022 

      Here is how you can successfully do that by select a column you want to Eliminate then you right click on the specific column. Then Member Selection > Eliminate > select the column you want to Eliminate.

      and once that is done that specific column will be hidden 


      Please reach out if this does not answer your question🙂.

      • Amy_Christophers
      • 7 mths ago
      • Reported - view



      Thanks for your reply.  This doesn't work for us as we are using a Mix. We are able to do this for examples on Consumer sales however on a Mix column we only have the options as per below screenshot.


      We can either hide all 'vs LY' which then removes all 'vs LY %' for every column. Or the option to hide all sales for that period. Again which would hide not what we need.

      • Nkhensani_Khoza
      • 7 mths ago
      • Reported - view

       your screenshot is not not so clear but I see the second option within eliminate that you can select rather then the 'vs LY'


      something like this option 


    • Leading Retail Trading Teams to Success
    • Georgina_Webster
    • 7 mths ago
    • Reported - view

    Hi Amy 

    Are you able to access the Eliminations wizard from the Query tab? 

    If you click on this icon, it will open a panel below the canvas where you can select items to eliminate. 

     Please excuse this example - it is a simple training document - but hopefully you will get the idea. 

    By clicking on the + symbol for elimination targets it will show the chips for measures and values available which you can select as required and then use the Hierarchy information that appears to select elements.    

    In this case I have selected to eliminate Accesories for Q2 2020.  Click Apply to apply your selections to the discovery. 

     Is this any help? 


Content aside

  • Status Answered
  • 7 mths agoLast active
  • 6Replies
  • 77Views
  • 3 Following