Error in pivot?

[resolvecomputing]

when we use one dimension and one aggregate the other dimensions are shown as empty columns. The users feel that this should not be displayed and is an error. can we suppress the unwanted dimensions when only one dimension is chosen? if so, how can we do it?

[paramvir]

Unwanted panes / dimensions can be hidden in toolPanel by toolPanel configuration sub-options.

https://paramquery.com/pro/api#option-toolPanel

[resolvecomputing]

I mean, I didn't choose Group column, so how can I hide other columns in table without aggregate column?
Thanks.

[paramvir]

Columns can be hidden in toolPanel with tpHide property.

https://paramquery.com/pro/api#option-column-tpHide

[resolvecomputing]

Even if I use tpHide the column is hidden in the panel but the column itself appears as an empty column. see the illustration attached.

[paramvir]

As mentioned earlier and in the documentation, tpHide is used to hide a column in toolPanel.

To hide a column in the grid, use column.hidden property.