Results 1 to 5 of 5

Getting correct grand totals when using calculated field in pivot table

Threaded View

stephme55 Getting correct grand totals... 03-04-2016, 03:40 PM
candybg Re: Getting correct grand... 03-04-2016, 06:52 PM
peterrc Re: Getting correct grand... 03-05-2016, 09:49 AM
Izandol Re: Getting correct grand... 03-07-2016, 12:14 PM
stasinek Re: Getting correct grand... 03-07-2016, 01:02 PM
  1. 03-04-2016, 03:40 PM #1
    stephme55 is offline
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Getting correct grand totals when using calculated field in pivot table

    I'm having trouble with a calculated field. I created a calculated field that divides one field by another. However, the grand totals (for rows/columns) isn't correct. Can somone take a look at attached and tell me why? Thankeshun.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. Calculated Item field to include grand total OR calculated field calculation on itself
    By Faya in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  3. Pivot table Grand Totals
    By Shane Moore in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 09:54 PM
  4. Need help with grand totals in pivot table
    By Missygal in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 02:10 PM
  5. Missing Grand Total for a Calculated Field in a Pivot Table
    By Robert Hamilton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2006, 02:20 PM
  6. Totals of calculated field in pivot table give incorrect results
    By Jake in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2006, 02:20 PM
  7. [SOLVED] Pivot Table Calculated Field (Grand total question)
    By Linda in forum Excel General
    Replies: 5
    Last Post: 08-03-2005, 06:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1