+ Reply to Thread
Results 1 to 2 of 2

Trouble with geting the required data from a pivot table

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    99

    Trouble with geting the required data from a pivot table

    So I am doing a project for school and it involves the use of a pivot table

    I can get the Pivot table created but I cannot figure out how to manipulate the data to solve for the question.

    the question is

    Sales Tax Data
    (note – the data for this problem has been fictionalized)
    The enclosed spreadsheet consists of two months worth of data received by the city related to monthly sales tax remittance. With this data, provide the following:
    • Create a new sheet that has totals by account number for each month that compares the year-over-year changes, including the percentage change. Group all accounts listed under “Specific outlet information is not available” as one item for this comparison. Please keep in mind that the same account number may be listed more than once during a month, and sometimes businesses come and go over the course of a year.

    any help would be greatly appreciated
    Attached Files Attached Files

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

    Re: Trouble with geting the required data from a pivot table

    Put all data in 1 sheet.

    Make a pivot table.

    Post it on the excelforum.

    Then ask the question you want to solve.

    We don't do homework (according to the forum rules), but are willing to giving you the help, so you could learn from it.
    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. [SOLVED] Trouble genrating correct pivot table data from a survey
    By Chrispelletier in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-03-2014, 07:38 PM
  2. [SOLVED] Pivot Table not retrieving required data
    By Excel Dumbo in forum Excel General
    Replies: 6
    Last Post: 07-19-2012, 06:25 PM
  3. [SOLVED] geting data from a table on a seperate sheet
    By Joe White in forum Excel General
    Replies: 8
    Last Post: 05-06-2012, 01:32 PM
  4. Replies: 2
    Last Post: 06-22-2011, 07:04 PM
  5. macro for geting data from pivot table (getdata)
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2011, 04:43 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