Multi-type Values in PivotGrid

Multi-type Values in PivotGrid

Posted by: georgekam96 on 25 November 2019, 9:53 am EST

• 

  georgekam96

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 November 2019, 9:53 am EST

  Greetings,

  We would like to know if there is any way to populate a PivotGrid with multi-type values, for example with both numbers and strings. We can see that this is possible on a FlexGrid, but it seems that we cannot achieve the same functionality on a PivotGrid. When we mix two different types on a PivotGrid, let’s say numbers and strings, the numbers are rendered correctly while the string values are replaced by zeros.

  Check the following JSFiddle example where the “expenses” value field consists of both numbers and strings: http://jsfiddle.net/DeadElectron/r9tgwobq/5/

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 26 November 2019, 12:53 am EST

  Hi George,

  This is expected behavior because the PivotGrid aggregates the data and it cannot find the sum of the string data type. So, it converts the string type to 0. MS-Excel also has the same behavior and our OLAP controls are based on excel.

  Regards,
  
  Ashwin