+ Reply to Thread
Results 1 to 2 of 2

Calculation in Pivot

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Calculation in Pivot

    I'm getting a too many records error when making a calculated item.

    So in the row I have divisions and in the columns I have years.
    Then I have 2 amounts in value.

    Now I want the calculated item to substract the 2 years (2017 - 2016) for bot values.
    Or even from 1 valuable would be ok, but also then I get the too many records to complete.

    Is it purely my big database (I have over 150.000 lines) or is there something else I am doing wrong?

  2. #2
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Re: Calculation in Pivot

    Ok to many records was not in the data.
    I was too many records in the rows.

    Had more than only division in the rows.
    Using less fields in the rows "solved" my error.
    Not really solving of course but I guess it is just a limitation I have to deal with.

+ 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 Calculation for Certain Purpose
    By DINGHUI0430 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-02-2014, 11:01 PM
  2. pivot calculation
    By olegvolf in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 01-02-2014, 06:28 PM
  3. Pivot calculation
    By ker9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-12-2013, 05:23 PM
  4. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  5. Calculated pivot table field using pivot table data in calculation
    By BrittleStar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2012, 05:35 PM
  6. Performing pivot calculation not using pivot
    By vemix in forum Excel General
    Replies: 3
    Last Post: 09-11-2012, 09:57 AM
  7. Pivot Calculation
    By sachinattri in forum Excel General
    Replies: 3
    Last Post: 03-18-2008, 10:50 AM
  8. How to Add a Calculation to a Pivot Table ?
    By Cheryl B. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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