+ Reply to Thread
Results 1 to 1 of 1

Creating a cost and revenue pivot. Gross margins % possible?

  1. #1
    Forum Contributor
    Join Date
    09-05-2007
    Posts
    148

    Creating a cost and revenue pivot. Gross margins % possible?

    I'm creating a pivot which is basically a P&L. It will essentially show costs and revenues. There will then be a subtotal for all revenue items and cost items.

    The grand total is a sum of these and is the net profit.

    I want to show the net profit as a % too but have no idea how to implement this into a pivot.

    Is this something I could/should be doing using power pivots?? Any suggestions or advice on how to approach this type of problem would be great.


    I've attached a sample workbook.
    Attached Files Attached Files

+ 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. Creating Revenue Recognition Waterfall
    By combust17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2016, 06:16 PM
  2. Replies: 2
    Last Post: 06-05-2013, 04:19 PM
  3. Need a Formula to turn daily data into a monthly summary for gross revenue
    By mikavelli17 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2012, 12:19 PM
  4. Grouping Revenue,Cost,Profit Data (Pivot Table 2007)
    By easycapital in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2008, 08:56 AM
  5. [SOLVED] cost revenue relationship
    By Karan Walia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2006, 03:55 PM

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