Jump to content
  • 0

Hide a column but keep aggregation total in tabular



I have a tabular report that has calculated fields using SELECT expressions to get various values related to each record in the results. I then have the main field in the results grouped and an aggregation to average (so the aggregated value is the same as the repeated calculated field value) the calculated field(s). 

The aggregation shows up at the 'top'  next to grouped main field. This is good (unfortunately tabular grouped sections only show the single grouped field and no related fields get to be in the top level with it- so I have to go this route). However..

What I need to do: hide the calculated field column that is repeated for each record in the results. I just need to show the aggregated average at the top. If I hide the whole column (which is easy) I lose the aggregation. 

Is there some way to hide the column results but keep the aggregation of that column? I was thinking maybe some way to change the style of the datapage to hide a specific column (or white the text to match the white background) by an id or something- but I don't know how to do that. Also, if there's a js way that'd be great too. 

I attached a screenshot- see how the 3rd and 4th column repeat the calculated field for every record- but the aggregation is at the top. I need to hide the repeated values (just not the aggregation). 


Any help would be very much appreciated- 


Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

I was trying something in the header and it almost works: 

#target table:nth-of-type(1) td:nth-of-type(3) {color: #ffffff;}

#target table:nth-of-type(1) th:nth-of-type(3) {color: #ffffff;}


The color:ffffff is to match the background so the column is still there but invisible. The problem is that the above changes the aggregate text color and not the results text color. I need the exact opposite. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...