Hi Venkata,
Thank you for writing to us.
In order to achieve the desired pivot table view, there are several steps to be taken:
- 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
- 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/
- 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/
- 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,
Mykhailo