Disable Aggregates for a single GridNumericColumn

3 posts, 1 answers
  1. Mike
    Mike avatar
    8 posts
    Member since:
    Oct 2014

    Posted 26 Oct 2016 Link to this post


    I am using the aggregates context menu to allow the user to choose their own aggregate functions, however, 1 particular column should not allow aggregation as each row is potentially showing a value in a different currency.

    Is there any way that I can disable aggregates for this column only? There doesn't appear to be any column setting relating to this.

    Thanks in advance,

  2. Answer
    Eyup avatar
    3953 posts

    Posted 31 Oct 2016 Link to this post

    Hello Mike,

    You can use the OnHeaderMenuShowing event handler to achieve this requirement:

    Similar to the javascript approach provided here:

    You can also check the following code-library or the attached web site sample:

    I hope this will prove helpful.

    Telerik by Progress
    Check out the new UI for ASP.NET Core, the most complete UI suite for ASP.NET Core development on the market, with 60+ tried-and-tested widgets, based on Kendo UI.
  3. Mike
    Mike avatar
    8 posts
    Member since:
    Oct 2014

    Posted 02 Nov 2016 Link to this post

    Thanks for the links Eyup, following the links you provided I simply hooked up the following to the OnHeaderMenuShowing event and it's now working perfectly.

    function ProjectGrid_HeaderMenuShowing(sender, args) {
      var disabledAggregateCols = ["Financial_BudgetCostForeign", "Financial_BudgetSellForeign"];
      var colName = args.get_gridColumn().get_uniqueName();
      var filterItem = args.get_menu().findItemByText("Aggregates");
      if (disabledAggregateCols.indexOf(colName) >= 0) {
      else {
Back to Top