🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Need format to generate pivot table

Venkata jaya prakash asked on December 30, 2019

Hi team I have attached the expected format in flex monster below,please share me the slice format so that i can form my json accordingly.

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster December 31, 2019

Hi Venkata,
Thank you for writing to us.
In order to achieve the desired pivot table view, there are several steps to be taken:

  1. Use the Field List to configure the slice and arrange hierarchies to rows and columns. You can also set up report filters & manage calculated values using Field List if necessary. For a more detailed overview of slice configuration and Field List functionality, please see the following link: https://www.flexmonster.com/doc/slice
  2. Use the options to hide subtotals and set the classic form as the default layout. For more information on options check out our doc page: https://www.flexmonster.com/doc/options/
  3. Using number formatting, set up the necessary currency symbol, decimal & thousands separators and the number of decimals shown after the decimal separator. A detailed tutorial can be found here: https://www.flexmonster.com/doc/number-formatting/
  4. If necessary, use the localization property to set a custom name for the column total. Here’s a quick outline on component localization: https://www.flexmonster.com/doc/localizing-component/

We’ve prepared a JSFiddle example in order to illustrate what can be achieved following the steps above. Please see it here: https://jsfiddle.net/flexmonster/vj7hopa2/
For more information on report configuration, feel free to check out the following page: https://www.flexmonster.com/api/report-object/
Please let us know if this helps.
Best regards,

Please login or Register to Submit Answer