+ Reply to Thread
Results 1 to 2 of 2

How to filter and clean the pivot table in excel?

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    1

    How to filter and clean the pivot table in excel?

    Hi everyone, I want to do something to my pivot table without touching the data table because it is not what I prefer. I attached my excel file in this post and I think the file should explain well what I want. Thanks in advance and hope to get some advise!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: How to filter and clean the pivot table in excel?

    It is easier to help when there is more detail in the explanation.
    That said, I assume that the issue is the pivot table is:
    1. Showing the value of the capital for rows where the trade cells are blank
    2. Combining capital values for dates i.e. 2019-07-16
    For some reason the table on Sheet1 will only produce pivot tables that offer the option of using the Date and Capital fields, so I copied the table to Sheet2 and then produced a pivot table from there.
    To overcome the issues listed above:
    1. Include a Trades field and then filter the Trades field to exclude blanks
    2. [optional] Format the Date field (this may need to be repeated when the pivot table is refreshed).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 1
    Last Post: 02-25-2018, 09:47 PM
  2. [SOLVED] Excel VBA with Pivot Table Filter
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2014, 02:08 PM
  3. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  4. Replies: 1
    Last Post: 02-07-2014, 03:04 AM
  5. Replies: 2
    Last Post: 07-19-2012, 05:07 AM
  6. Excel pivot table filter
    By nightfall24 in forum Excel General
    Replies: 1
    Last Post: 09-28-2010, 12:15 AM
  7. how to delete/clean out the row list in pivot table
    By john² in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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