Search the Community
Showing results for tags 'hide column'.
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-
Problem: under Tabular format there is no 'hide on blank value" I can only work under Tabular because of the agregation function (sum). Report -> tabular -> Results page fields So hide the colums(fields) where the value is blank Can someone help me please? Thank you Bart