Spreadjs PivotBy formula not producing same results as Excel

Spreadjs PivotBy formula not producing same results as Excel

Posted by: dean.kinnear on 20 August 2026, 9:46 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 20 August 2026, 9:46 am EST

  Compare the results for attached workbook and screenshots

  Thanks,
  
  Dean

  PivotBy.zip

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 21 August 2026, 5:38 am EST

  Hi,

  We were able to replicate the behavior on our end. However, we are not yet sure whether this behavior is expected.

  We have therefore discussed the issue with our development team for further clarification. The internal tracking ID is SJS-35708.

  We will update you as soon as we receive any further information from the development team.

  Regards,
  
  Priyam