Results 1 to 2 of 2

Trouble with geting the required data from a pivot table

Threaded View

nsmjc Trouble with geting the... 08-19-2014, 01:24 AM
oeldere Re: Trouble with geting the... 08-19-2014, 02:05 AM
  1. #1
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    100

    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

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