Calc Pivot Table Total Sum column ignoring data format

asked 2019-01-08 22:43:40 +0200

AdmFubar gravatar image

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

edit retag flag offensive close merge delete