I have a pivot table source , that has a column for the amounts of purchased items. That column is formatted as currency. The field is called sum_amount. The pivot table recognizes the currency format of the source for sum_amount fields in the table, but the total_sum_amount on the far right column, the format is ignored. Has anyone else noted this? or is there something i’m missing when i am create a pivot table?
Here is the version of LO I use.
Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (en_US); Calc: CL