+ Reply to Thread
Results 1 to 4 of 4

power query with Pivot table (calculating 2 different date value difference)

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    power query with Pivot table (calculating 2 different date value difference)

    Hi to all,

    I'm quite new to pivot table and i trying to create a custom difference column for daily sales. Was wondering can anyone guide me along. Tried calculated field and calculated item but not sure how should i add in for the formula.

    1.jpg

    As you can see from the image, I would like to add in the difference column at the E column showing the total difference example dated 30/11/17 to the latest date loaded from my data. And the difference value can also be change according to the date I would like to compare example 30/11/17 and 1/12/17.

    is this possible for pivot table?
    Appreciate any help!

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: power query with Pivot table (calculating 2 different date value difference)

    1. Excel 2003 doesn't support PowerQuery & PowerPivot - change Excel version in your profile
    2. No one want retype your data - attach example, desensitized excel file (xlsx, xlsm, xlsb) with BEFORE (what you have) and AFTER (what you want to achieve)

    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    Last edited by sandy666; 12-03-2017 at 01:12 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: power query with Pivot table (calculating 2 different date value difference)

    Quote Originally Posted by sandy666 View Post
    1. Excel 2003 doesn't support PowerQuery & PowerPivot - change Excel version in your profile
    2. No one want retype your data - attach example, desensitized excel file (xlsx, xlsm, xlsb) with BEFORE (what you have) and AFTER (what you want to achieve)

    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    Hi Sandy,
    Thanks for the reply but probably there's a misunderstanding. I actually just want to know is it possible to add a custom column to calculate the difference for daily value in the pivot table as by default there are only grand sum total option. Doesn't really require anyone to retype my data whereas if possible, can provide me with an example or any helpful tips will be great!

    Cheers

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: power query with Pivot table (calculating 2 different date value difference)

    There is no Calculated Column in PivotTable. You can add Calculated Field
    or
    in source add column with calculation then create PivotTable

    but Ex2003 is not my favorite version

+ 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. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. [SOLVED] Pivot table from power query
    By pccamara in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 05-17-2017, 10:09 AM
  3. Calculating ppts difference from % of column total data in a pivot table
    By TJGriffiths in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-10-2017, 09:49 PM
  4. power pivot , appended data , difference of columns
    By Hassan1977 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2017, 05:04 AM
  5. How to calculate Difference (%) in Power Pivot
    By Pony08 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-05-2015, 06:54 PM
  6. [SOLVED] Calculating difference on Pivot Table Totals
    By PSM in forum Excel General
    Replies: 0
    Last Post: 01-12-2006, 11:40 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