Need format to generate pivot table

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,
Mykhailo