Column Header Caption customization

Hello, Sumukh,
 
Thank you for your questions.

Please see our answers below.
 
1) About column header customization:
1.1) Flexmonster provides an option to hide aggregation labels like "Total Sum of", "Sum of", etc. in the column/row titles.
This can be done by setting the showAggregationLabels parameter to false (see: https://www.flexmonster.com/api/options-object/ ), for example:

options: {
   showAggregationLabels: false
}

Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/Lsp1hcz4/
 
 
1.2) If you wish to customize the column labels, you can specify the desired ones via localization (please see: https://www.flexmonster.com/doc/localizing-component/ ), for example:

global: {
  localization: {
     aggregations: {
        sum: {
               caption: "My Sum",
               totalCaption: "{0} - My Sum",
               grandTotalCaption: "{0} - My Sum Total"
        },
        count: {
               caption: "My Count",
               totalCaption: "{0} - My Count",
               grandTotalCaption: "{0} - My Count Total"
        }
    }
  }
}

Here is a link to Flexmonster's localization files for reference: https://github.com/flexmonster/pivot-localizations/blob/master/en.json
By specifying the localization changes in the global property (see: https://www.flexmonster.com/api/global-object/ ), these changes will be common for all reports.
 
We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/rpxse4v1/
 
2) About "Calculate Individual Values":
The individual property allows the formula to be calculated using raw values.

For example, the formula sum('Price') * sum('Amount') will be calculated differently, depending on whether the calculate individual values option is selected:
2.1) If calculate individual values is selected, it will be calculated like this: 174 * 36 + 225 * 44
2.2) If calculate individual values is not selected, it will be calculated like this: (174 + 225) * (36 + 44)
You can check this out in the following example: https://jsfiddle.net/flexmonster/7mtwxqow/.
 
Please let us know if this helps.
 
You are welcome to contact us in case of further questions.
 
Best Regards, 
Vera

Hello, Sengupta,
 
Thank you for reporting the issue and providing a detailed explanation.
Our team will take a look at it and return to you with a fix ETA 14th of June.
 
As a temporary workaround, we would like to suggest using the customizeCell API call. 
We have prepared an example for illustration: https://jsfiddle.net/flexmonster/0pf9s7xk/. On lines 32-40, we removed "(none)" from the caption by changing the text of the cell. Please note that the commented code is just an alternative option for changing the text. 
Also, we would like to draw your attention to lines 24-26 and 84, which are important for the correct work of the sample.
 
Hope it helped!
Feel free to reach out to us if any additional questions arise.
 
Kind regards,
Milena

Hello,
 
It seems we answered a similar question on another forum thread.
Please see our answer by the following link: https://www.flexmonster.com/question/custom-data-source/.
 
Kind regards,
Illia

Hello, Sengupta,
 
We are pleased to inform you that the issue with the none aggregation appearing in the measure caption was fixed.
This is available in the 2.9.1 version of Flexmonster: https://www.flexmonster.com/release-notes/.
 
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please contact us in case any questions arise.
 
Best regards,
Milena

Hi, Sengupta,
 
Hope you are doing well!
 
Our team is wondering whether the recent fix helped.
Please let us know if everything works fine.
 
We are looking forward to hearing from you.
 
Kind regards,
Milena