Posted 8 June 2020, 6:59 am EST
Along with the group names , the group aggregates values are coming in flex sheet grouping. How to remove that?
I dont want to show the aggregates along with the group names
Posted by: ambarish.banerjee12 on 8 June 2020, 6:59 am EST
-
ambarish.banerjee12
-
ashwin.saxena
Posted 9 June 2020, 12:28 am EST
Hi,
In the provided sample, the aggregates were already not displayed because none of the columns have their aggregate property defined. So, it seems that you are referring to a different item.
If you are referring to the whole group row (which can be expanded/collapsed), then you may hide them by setting the showGroups property of FlexSheet to false.If you are referring to the count displayed in the grouped rows, then you can remove the count by using groupHeaderFormat.
If you are actually referring to the aggregates displayed in the group row, then you may hide them by setting the columns aggregate property to wijmo.Aggregate.None, if you do need aggregates. But, if you need aggregates but only wish to not display them on the sheet, then you may use the formatItem event of the flexsheet to hide them.
Please refer to the updated sample link below:
https://stackblitz.com/edit/js-tm96c5
Regards,
Ashwin -
ambarish.banerjee12
Posted 9 June 2020, 6:03 am EST
Yeah I pasted a wrong url. Actually I have inserted a group row after every group which stores the aggregate of that group. Now the group row on the top also shows the aggregates, the group row footer I inserted also shows aggregates. I want to hide the aggregates from the top one which shows the name of the group
-
ashwin.saxena
Posted 10 June 2020, 5:32 am EST
Hi,
As per your requirements, you can use the formatItem solution:
But, if you need aggregates but only wish to not display them on the sheet, then you may use the formatItem event of the flexsheet to hide them.
Please refer to the updated sample below that demonstrates your requirements:
https://stackblitz.com/edit/js-xxkltt
~regards
