Hi,
Can you please provide help on how to refresh column grouping data when we reload the grid / bind new data to grid after first load? Also, how to rename column grouping column name and provide title/label to first column on grand summary row?
The pivot works fine and successfully set column grouping and row grouping for the first load of data into grid. However, when I try to submit the search and refresh the grid with new data, the row grouping data has changed as per new data but for column grouping (both column name + data) does not get change based upon new data. What option does we need to set so even column grouping also refresh when we have new data to bind.
Also, I want to provide custom name to aggregate column (column grouping aggregate columns) and set custom value/ label for grant summary row on pivot grid. Can you suggest what is the setting to perform this?
