Questions How to get the Margin Percentage in a Pivot

Acumatica Generic Inquiries & Pivot Tables

Last Post by Richard Whight 5 years ago

1 Posts

1 Users

2 Reactions

1,981 Views

RSS

Posts: 17

Richard Whight

Topic starter

December 12, 2021 9:08 pm

(@richard-whight)

Eminent Member

Joined: 5 years ago

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

12 Forums
2,533 Topics
11 K Posts
68 Online
2,438 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)