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

[Diego]

Hi... I use a pivotGrid and I need to use a datafield with format "HH:MM" in a AggregateField, is that possible?

[Eyup]

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

 

 

[Tim]

Hi Eyup,

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

Thank you.

[Eyup]

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

 

 

[Tim]

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.

[Tim]

Thanks for the reply,

My question above is being answered by other post @ http://www.telerik.com/forums/radpivotgrid-calculated-item

[Eyup]

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