+ Reply to Thread
Results 1 to 2 of 2

How to add Month by Month to get YTD using Getpivotdata in Google sheet

  1. #1
    Registered User
    Join Date
    06-04-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    18

    How to add Month by Month to get YTD using Getpivotdata in Google sheet

    Hi All,

    Hi Team,

    I'll appreciate if someone could please review my query on how I could wrap sum into vlookup and getpivotddata to arrvie at YTD/current costs.

    I'll appreciate a swift response.

    Thanks for your support
    Attached Files Attached Files
    Last edited by Johnyam54; 06-20-2022 at 10:45 AM. Reason: Updated Question

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to add Month by Month to get YTD using Getpivotdata in Google sheet

    With Power Query to re-arange the data.

    After that a pivot table.

    With YTD (rolling data)

    See the sheets with the name Oeldere.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. How to add Month by Month to get YTD using Getpivotdata in Google sheet
    By Johnyam54 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-17-2022, 04:27 PM
  2. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  3. Replies: 1
    Last Post: 11-14-2018, 09:22 AM
  4. Button click to display current month only data from a sheet in excell and GOOGLE
    By dori2o in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2017, 08:24 AM
  5. [SOLVED] Count number of occurrences in month (google sheet)
    By Juliansmity in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2015, 12:17 PM
  6. [SOLVED] Macro to cut and paste current month sheet into the relevant month chosen by a drop down
    By scotty22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2015, 09:07 AM
  7. Dragging Month in GetPivotData
    By easycapital in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2008, 09:06 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