Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

[Bug Report] Formula returns wrong values when hierarchies are moved in the grid

Projet Data asked on July 9, 2020
  • Version: Pivot Table for JSON data sources v2.8.10
  • Browser: Chrome Version 83.0.4103.116 on Windows 10
  • Link to reproduce:
  • Steps to reproduce:
    • Open attached JSFiddle
    • See values for measure “Balance Start” on 2013 and Totals (e.g. for Country “BE” it is 1 476.76 in 2013)
    • In the grid, drag the hierarchy “Country” from the rows to the columns and then drag it back from columns to rows (to restore initial configuration)
    • See values for measure “Balance Start” on 2013 and Totals once again
  • Observed behavior:
    • “Balance Start” on 2013 and in Totals has different values (e.g. for Country “BE” it is now 2 191.47 in 2013) (see attached screencap)
  • Expected behavior:
    • “Balance Start” (or any measure based on a formula) should not return different values when hierarchies are moved through drag&drop and then restored back to the initial configuration
  • More details:
    • “Balance Start” is a formula based on 2 runningtotalsofrow calculations. Bug doesn’t seem to occur with only one runningtotalsofrow in the formula (untested with other aggregations)


1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster July 10, 2020

Thank you for reporting the problem.
The fix is going to be provided with a minor update ETA Aug 11.
We will notify you as soon as the version with a fix is released.
Do not hesitate to contact us in case further questions occur.

Please login or Register to Submit Answer