+ Reply to Thread
Results 1 to 2 of 2

need to calculate:Pivot Table % calculation

  1. #1
    CSAH
    Guest

    need to calculate:Pivot Table % calculation

    I need to calculate a % based on a grouped totalin a pivot table. I've tried
    calculated field & items but can't get them to work. If I use a calculated
    item I get this:

    Reg1 Reg2
    Item1 Sales 100 200
    Item2 Sales 200 300
    Total Sales 300 500

    Item1 Margin 50 150
    Item2 Margin 100 200
    Total Margin 150 350

    Item1 Margin% 50% 75%
    Item2 Margin% 50% 66%
    Total Margin% 100% 133% When the values S/B 50% and 70%

    I know this should be easy but I can't figure it out.
    Thank you all very much
    --
    CSAHP

  2. #2
    Debra Dalgleish
    Guest

    re: need to calculate:Pivot Table % calculation

    The subtotals in the pivot table will all use the same function -- in
    this case they're all SUM functions. You could use conditional
    formatting to hide the Total Margin% row, and do your own calculation
    outside of the pivot table.

    CSAH wrote:
    > I need to calculate a % based on a grouped totalin a pivot table. I've tried
    > calculated field & items but can't get them to work. If I use a calculated
    > item I get this:
    >
    > Reg1 Reg2
    > Item1 Sales 100 200
    > Item2 Sales 200 300
    > Total Sales 300 500
    >
    > Item1 Margin 50 150
    > Item2 Margin 100 200
    > Total Margin 150 350
    >
    > Item1 Margin% 50% 75%
    > Item2 Margin% 50% 66%
    > Total Margin% 100% 133% When the values S/B 50% and 70%
    >
    > I know this should be easy but I can't figure it out.
    > Thank you all very much



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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