+ Reply to Thread
Results 1 to 2 of 2

Pivot table with additional columns

  1. #1
    Registered User
    Join Date
    10-22-2020
    Location
    Melbourne
    MS-Off Ver
    Home 365
    Posts
    8

    Pivot table with additional columns

    Hi all,

    I'm trying to create a pivot table showing a list of transactions. I want to group the transactions by Category, then by a description, and then list every transaction ordered by date, with subtotals for each Category.

    I have attached an example file showing both the pivotal table I have set up, and how I want it to look. The problem is it is creating a new drop down for each date with the transaction details listed as a subcategory. I would like the transaction details to show alongside the date in a separate column. It is also subtotaling transactions of the same date from the same category (see highlighted in pink in attached file). I just want to show each individual transaction with the date and transaction details listed side by side.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Home & Business 2016
    Posts
    455

    Re: Pivot table with additional columns

    The Value fields are always shown on the right side of the PivotTable. The closest format is to choose the Show in Tabular Form in the Report Layout.

    Pivot table with additional columns.png
    Attached Files Attached Files

+ 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. Replies: 4
    Last Post: 03-03-2019, 02:24 PM
  2. [SOLVED] Adding additional field to pivot table (but not for each column)
    By cprobertson1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-21-2017, 07:51 AM
  3. Additional Columns in a connected table
    By cjwatts in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2017, 09:42 AM
  4. Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  5. Pivot Table adding additional columns excel 2007
    By runner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2012, 12:24 PM
  6. Adding additional colums in the pivot table
    By Excel Dumbo in forum Excel General
    Replies: 7
    Last Post: 08-21-2012, 04:00 AM
  7. [SOLVED] Please respond: Need to create additional measure in pivot table
    By Angel in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 03:25 PM

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