Hey, Attached is the screenshot of a pivot table.
I want to remove the decimal values from this data ie. instead of 207.00, I want Q1 data in this table to be visible as 207
Hello!
Unfortunately, there is no ability to format specific column. You can specify format for all decimal values by using the following message key:
pivottable.floatFormat.digitsAfterDecimal=0
Hi, I got the solution using aggregation mode as “Integer Sum”.
Thanks for your suggestion.