Results 1 to 6 of 6

Calculated field from same column different years in a pivot

Threaded View

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Calculated field from same column different years in a pivot

    Hello experts,

    Is there even possible to create a calculated field in a pivot, using same column but in different years?
    This field should be the percent for the progress of the quantity or value for January 2023 vs January 2024.

    I've created a dummy file just to get an ideea of what my goal would be. The attached file does not contain the pivot itself but I can create a dummy pivot if you think that my goal is even possible.

    Thank you very much!
    pivot.png
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot Table Calculated Field - Sum of Column A * Min of Column B
    By Whizbang in forum Excel General
    Replies: 8
    Last Post: 07-20-2021, 08:49 AM
  2. [SOLVED] Pivot Calculated field using values of a Column
    By jomili in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-27-2017, 10:17 AM
  3. Calculated Field / Column / Item in Pivot Table
    By rashid.mehmood in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-23-2015, 01:58 PM
  4. [SOLVED] Referring to a Sub-Field on Calculated Field Pivot Table Column?
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-27-2014, 02:02 PM
  5. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  6. Adding new calculated/column field to pivot table
    By MARYAN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2010, 05:34 AM
  7. Replies: 3
    Last Post: 02-23-2009, 10:07 AM

Tags for this Thread

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