+ Reply to Thread
Results 1 to 2 of 2

PivotTable to Calculate Invoice Margin - HELP

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016, Office 365
    Posts
    48

    Unhappy PivotTable to Calculate Invoice Margin - HELP

    I'm combining data from multiple sheets in a PivotTable (Excel 2013 allows this) in order to calculate the margin obtained per each item in a invoice and the total margin in the invoice, in case the invoice has multiple items.

    The point of contention is that sometimes there are products that when sold in a certain quantity there will be 1 item free of charge, for instance:

    15 cases of item X (and on the next line of the invoice)
    1 case of item X free of charge

    This means that the margin of the product X will decrease. Can anyone help me go about this calculation in my PivotTable ?
    Thank you.

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: PivotTable to Calculate Invoice Margin - HELP

    Hi Alienontherun,

    You can use Calculated field in Pivot table to get the result.

    Regards,
    AM

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Distance between Table's Last Row and Page Margin
    By ClassMain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2015, 12:03 PM
  2. Net Margin Formula Using SUM= To Calculate Gross Margin Cells
    By jezrp22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2015, 08:41 PM
  3. [SOLVED] Calculate best Margin
    By cell-dweller in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2014, 12:40 AM
  4. [SOLVED] Calculate Sales price with Net Margin 10% Goal, if Cost goes up or down
    By Bitto in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-22-2013, 07:26 AM
  5. Need Formula or Function to calculate Margin (reverse of Percent a
    By Ken in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2005, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1