hide columns in visualizer + sub-summary

Hello

Is it possible to hide rows column in visualizer ? I am using YY / YYMM and YYmmm as rows (YYMM is only used to sort YYmmm) and I'd like to hide YY/MM.

YY	YY/YYMM	YYmmm
2020	2020-01	2020-January	100
2020	2020-02	2020-February	110
2020	...	...	...
2020	2020-12	2020-December	200
		total	500
2021	2021-01	2021-January	190

I tried to modify column with table formatting but nothing has changed.

I know to add grand summary but I cannot add summary for YY Column.

Thank you for helping me

Find more posts tagged with

Comments

Legacy Contributor

In a tabular report you can click on the down-arrow on any column in the report and choose Hide column. See screenshot

I'm not sure what kind of summary you want for the YY Column. The summary is just for aggregations (SUM, Avg, etc.)

Legacy Contributor

To hide a column and to add an additional break to show sub-summary, I use the down arrow next to the column names in the table.

Here is a basic report

Now let's say we do not want to see Week Start Date, to do that I click on the arrow and choose Hide Column

Then to add places you want sub totals, you can use the same arrow to choose Break By which will force the breaks wherever you want them in your data.

Hopefully this helps.

Erick Chabenat

Sorry Cindy

I was talking about Designer, not visualizer.

I have found how to add grand summary, hide a column stay impossible.

Erick Chabenat

Sorry

I was talking about Designer, not visualizer.

I have found how to add grand summary, hide a column stay impossible.

Legacy Contributor

@erick-chabenat move the column(s) that you want to hide to the "Undisplayed Content" section

Erick Chabenat

yes Cindy but, doing that, I loose the sorting I want to keep

I need this field to sort data and calculate summary but I don't want it to be displayed

Copyright © 2025 Infor. All rights reserved.