Results 1 to 3 of 3

Thread: Pivot Help - Included Filtered Rows in Totals
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Help - Included Filtered Rows in Totals

    Good Afternoon,

    I am trying to edit the row subtotals and grand totals in a pivot table to include items that have been hidden by the filter. Here is my data:





    The data table is top left, pivot top right (with filter applied to remove 0's from B) and bottom left is a snip of the pivot without filter applied.

    You can see the grand total in the snip is 1.95 for A and 25 for B when no filters are applied. What i want to do is filter any rows in B that are zero, but still have 1.95 / 25 displayed as the grand total (as compared to 0.3 / 25) and the same for each subtotal. Can anyone point me in the right direction please ?

    I have a secondary question also - is it possible to turn a total off for a particular column ? As a workaround for this I was considering using conditional formatting to create a formula that coloured the text white if a certain condition was met.

    Many thanks in advance for your help

  2. #2
    New Member
    Join Date
    Apr 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Help - Included Filtered Rows in Totals

    Just to note, I have tried following these instructions but I cannot see the options mentioned in my options box....

    https://support.office.com/en-us/article/subtotal-and-total-fields-in-a-pivottable-173f5b30-b546-4293-87d2-aee638f74e7d



  3. #3
    New Member
    Join Date
    Apr 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Help - Included Filtered Rows in Totals

    No one can help ?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •