By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
1
Posts
1
Users
2
Reactions
1,924
Views
December 12, 2021 9:08 pm
Hi All
I've written a GI to pull out all the sales with net sales, costs, margin and margin percentage. All is good on the row by row level but when I go to pivot the best I can do is average the margin percentage column. This gets close but it's not right still.
If any of you do excel then I'm trying to do this but in a GI Pivot.
Any help other than doing in Excel or Power BI would be greatly appreciated.
Rich
Online Members
