Does anyone know if there is a way to create a calculated field in a pivot table GI within Acumatica?
Am trying to sum totals sales / costs / margin and margin % by various objects. My GI has each of these at the row level, but when summing in a pivot table, margin % is obviously not correct. Pivot function seems to support % of row / column, but not % of a specific column (ideally would just sum margin / price for %margin).
Any suggestions, greatly appreciated.
Thanks,
Dave