Get Free Trial
Get Free Trial

Column Header Caption customization

Resolved
Sumukh asked on October 8, 2019

Hi,
1. I need to change the title of the column headers of all fields in the value section.
Ex: Total Sum of Revenue or Total Max of Date
I need to remove the “Total” or if possible keep just the field name Revenue or Date.
Is it possible to customize it?
 
2. Also need to know the functionality of Calculate Individual Value Checkbox inside Calculated Values Section.

1 answer

Public
Vera Didenko Flexmonster October 9, 2019

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/doc/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

Please login or Register to Submit Answer