+ Reply to Thread
Results 1 to 5 of 5

Calculated item of Total in Pivot Table

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2003
    Posts
    7

    Calculated item of Total in Pivot Table

    Hi there

    I'm new at the forum and an advanced user in excel but i'm having a problem on my pivot tables.
    I introduced a percentage calculated item on my pivot table but on the far right where is the column that sums, it's "summing" all the percentages.

    Is there any way to fix this?
    What i want is, in the image below, replace the yellow cells with a percentage (Margin / Sales)

    test.jpg

    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Calculated item of Total in Pivot Table

    The simplest way is probably to add Sales and Costs columns to your source data and then use calculated fields rather than calculated items. See attached workbook.
    Attached Files Attached Files
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Calculated item of Total in Pivot Table

    hi there
    how did you put the margin and percentage? it's not in data sheet.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Calculated item of Total in Pivot Table

    I added calculated fields, rather than calculated items. The process is basically the same though.

  5. #5
    Registered User
    Join Date
    04-02-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2003
    Posts
    7

    [SOLVED] Re: Calculated item of Total in Pivot Table

    thanks.
    problem solved
    Attached Files Attached Files
    Last edited by nfcascalheira; 10-27-2014 at 07:24 AM. Reason: solved the question

+ 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. Pivot Table Calculated Item Field Grand Total Not using Formula
    By gav0101 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2014, 11:46 AM
  2. Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  3. calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 PM
  4. calculated item does not work in grand total column- Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 PM
  5. [SOLVED] calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:30 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