PivotGrid Field Setting - % of X Total property has wrong associated format

PivotGrid Field Setting - % of X Total property has wrong associated format

Posted by: james.ingham on 20 April 2020, 6:25 pm EST

• 

  james.ingham

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 6:25 pm EST - Updated 3 October 2022, 4:27 pm EST

  Hi Wijmo team,

  We noticed a minor issue at the Field Setting popup of the Pivot Panel. When you select ‘% of grand/row/column/etc total’ in the “Show As” property, its associated format does not look correct. It should be in Percentage as opposed to Integer.

  We are also wondering whether there’s a way to customize the default format of each of those items in the “Show As” box? E.g. I want the default format of ‘% of Grand total’ to be ‘p2’. Is it possible?

  Thanks a lot!

  

  355×503 31.6 KB

  

  749×582 78.6 KB

  

  766×578 60.5 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 21 April 2020, 3:33 am EST

  Hi James,

  We have forwarded this issue to the dev team with internal tracking id 431804. We will update you once this issue is fixed.

  For updating the format when showAs is changed in the field settings dialog, you may override the editField method of the PivotEngine and get the reference of the showAs ComboBox. Then you can handle the selectedIndexChanged event of this combobox and update the value of format accordingly.

  https://stackblitz.com/edit/js-hzw9cb

  Regards,
  
  Ashwin

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 28 April 2020, 4:38 am EST

  Hi James,

  Regarding #431804, the issue has been fixed in the latest nightly build of Wijmo. You may verify the same using the sample below:

  https://stackblitz.com/edit/js-ypazq7

  PS: Nightly builds have not passed through the QA cycles as all of our release builds do. Therefore, they are not suitable for production.

  ~regards