+ Reply to Thread
Results 1 to 2 of 2

Calculated Fields in Pivot table

  1. 03-16-2017, 06:48 AM #1
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Calculated Fields in Pivot table

    Hi,

    I am trying create a column with calculated field(Querydate) which is the date function of Month and year for various type of calculations such as YTD, MAT etc.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-16-2017, 11:43 AM #2
    Biplab1985
    Biplab1985 is offline
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Calculated Fields in Pivot table

    Calculation is correct but pivot do not filter, any reason?

    Please Login or Register  to view this content.
    Last edited by Biplab1985; 03-16-2017 at 11:47 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Calculated Fields in a Pivot Table when 'Fields' appear over Muliple Lines
    By HangMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  2. Calculated fields in a pivot table
    By cmarston1500 in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 06-12-2013, 12:24 PM
  3. Help w/Pivot Table Calculated Fields
    By pcat29 in forum Excel General
    Replies: 1
    Last Post: 01-28-2012, 06:28 AM
  4. How many calculated fields can I put in a pivot table?
    By punter in forum Excel General
    Replies: 0
    Last Post: 03-16-2009, 05:42 PM
  5. Pivot Table calculated fields
    By tigertim71 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2008, 04:58 AM
  6. calculated new fields in pivot table
    By barkarlo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-29-2007, 07:32 AM
  7. Pivot Table with Calculated Fields
    By Florence in forum Excel General
    Replies: 3
    Last Post: 01-20-2006, 10:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1