+ Reply to Thread
Results 1 to 2 of 2

Gross Profit- Power Pivot

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    Gross Profit- Power Pivot

    I have multiple tables linked and generating a basic pivot P&L showing revenue, cost of sales, other expenses. 1 table (transactions) contains all of the revenue and expense transactions along with an associated account index. This table is linked to a Chart table holding the index and associated account number as well as roll up grouping (revenue, cost of sales, other expenses, etc...) for a given account number. What I'm attempting to do is have the pivot calculate a gross margin by netting the revenue and cost of sales roll up grouping totals. Multiple searches have left me wondering if I have to use some form of DAX to create. Is there a much simpler way to do this?

  2. #2
    Registered User
    Join Date
    12-03-2013
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    [Solved] Gross Profit- Power Pivot

    Created additional grouping for revenue and cost of goods sold accounts with the label "Gross Margin". Then labled other expenses and revenues as such. Primary row gouping now uses this grouping to get a nice gross marging subtotal.

+ 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. formula for gross profit inc VAT
    By Martin@Stag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2013, 06:09 PM
  2. Gross Profit Percentage
    By beaudroix in forum Excel General
    Replies: 2
    Last Post: 03-16-2012, 01:18 PM
  3. how to work out gross profit on items
    By klansman7 in forum Excel General
    Replies: 1
    Last Post: 07-24-2006, 02:55 PM
  4. Calculate gross profit based on varying percentages
    By Pasko1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2006, 10:20 PM
  5. gross profit margin formula
    By julmcgrath in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 11: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