Can I use a datafield with format "HH:MM" in a PivotGrid:AggregateField?

7 posts, 0 answers
  1. Diego
    Diego avatar
    1 posts
    Member since:
    Feb 2014

    Posted 25 May 2014 Link to this post

    Hi... I use a pivotGrid and I need to use a datafield with format "HH:MM" in a AggregateField, is that possible?
  2. Eyup
    Admin
    Eyup avatar
    3015 posts

    Posted 29 May 2014 Link to this post

    Hi Diego,

    Please note that using DateTime fields for PivotAggregateField is not recommended. You can use numeric fields instead, for instance:
    <telerik:PivotGridAggregateField DataField="Freight" Aggregate="Sum" DataFormatString="{0:C}">
    </telerik:PivotGridAggregateField>

    Hope this helps.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Tim
    Tim avatar
    57 posts
    Member since:
    Oct 2013

    Posted 02 Jul 2014 in reply to Eyup Link to this post

    Hi Eyup,

    May I ask how can I get access to dataformatstring of calculated item in the radpivotgrid column?

    Thank you.
  5. Eyup
    Admin
    Eyup avatar
    3015 posts

    Posted 07 Jul 2014 Link to this post

    Hi Tim,

    Please note that the PivotGridCalculatedItem does not have a DataFormatString property. You can control its formatting individually for each cell or set the default DataFormatString for its parent PivotGridColumnField:
    http://www.telerik.com/help/aspnet-ajax/pivotgrid-custom-data-calculations.html

    Hope this helps.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Tim
    Tim avatar
    57 posts
    Member since:
    Oct 2013

    Posted 07 Jul 2014 in reply to Eyup Link to this post

    Thanks Eyup,

    How can I access the format of e.CalculatedValue cell in particular?

    My problem is that I'm trying to get my calculated item to be in percentage where my column is in other format.

    Best Regards.
  7. Tim
    Tim avatar
    57 posts
    Member since:
    Oct 2013

    Posted 08 Jul 2014 in reply to Tim Link to this post

    Thanks for the reply,

    My question above is being answered by other post @ http://www.telerik.com/forums/radpivotgrid-calculated-item
  8. Eyup
    Admin
    Eyup avatar
    3015 posts

    Posted 08 Jul 2014 Link to this post

    Hi Tim,

    I'm glad the suggested approach by my colleague has proven helpful.
    You can turn to us if new questions arise.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017