How to prevent grand total calculation for string fields(dimension field) on pivot flat type. find the link bellow.
Thanks and regards
Thank you for your question.
The grand total is calculated for strings with numbers because, by default, fields containing numbers are parsed as numbers during type resolution. We suggest explicitly assigning the
"string" type for string fields (that contain numbers) inside the MappingObject:
Please see this JSFiddle for reference.
Alternatively, you can disable all grand totals with the
showGrandTotals: "off" option. You are welcome to check the example.
Hope you will find this information helpful. Feel free to contact us if further assistance is needed.
Is there any configuration for me to avoid the grand total only for the dimension field(even an integer field) instead of turning it off for all?
Currently, there are no configurations allowing you to disable grand totals for specific numeric fields.
We have added this feature to our customer’s wishlist and will notify you in case of any progress.