Pivot View - Bind TimeSpan to Field with Formatting

[Travis Bay]

I am trying to bind a timespan to the PivotView.  Below is my code, the formatting should be Days, Hours, Minutes, and Seconds but all I get are constant results of the following (31.07:00:00):

Is it not possible to bind a timespan to a pivot view?

<SfPivotView TValue="TurnaroundtimeDto" @ref="@_pivot" Height="800" EnableValueSorting=true ShowTooltip=false ShowToolbar="false">

<PivotViewDataSourceSettings TValue="TurnaroundtimeDto" DataSource="_turnAroundTimeData" ExpandAll=true EnableSorting=true ShowGrandTotals="false">

<PivotViewColumns>

<PivotViewColumn Name="TypeDescription" Caption="Type"></PivotViewColumn>

<PivotViewColumn Name="TypeSubDescription" Caption="Type Sub"></PivotViewColumn>

</PivotViewColumns>

<PivotViewRows>

<PivotViewRow Name="State" Caption="Jurisdiction"></PivotViewRow>

</PivotViewRows>

<PivotViewValues>

<PivotViewValue Name="TurnAroundTimeFrame" DataType="time" Caption="Turn Around Time"></PivotViewValue>

</PivotViewValues>

<PivotViewFormatSettings>

<PivotViewFormatSetting Name="TurnAroundTimeFrame" Type="time" Format="d.hh:mm:ss"></PivotViewFormatSetting>

</PivotViewFormatSettings>

</PivotViewDataSourceSettings>

<PivotViewGridSettings ColumnWidth="120"></PivotViewGridSettings>

</SfPivotView>

[Sivamathi Natarajan]

Hi Travis, 

  

Thanks for contacting Syncfusion support. 

  

We regret you to let you know that, we cannot achieve this requirement – “To display the time span in pivot table”. Because, the aggregated values are displayed in the value cells. 

  

Regards, 

Sivamathi.