Pivot Table problem
Results 1 to 1 of 1

Thread: Pivot Table problem
Thanks Thanks: 0 Likes Likes: 0

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

    Default Pivot Table problem

    Hi All
    I am having a problem with a pivot table which I need help with please. From the data table below I want to get the bootom 5 values but exclude the blank cells from the cvount in the pivot table.
    The pivot table below shows them as 0 and includes them in the bottom 5.

    Data Table
    TANO NAME SUM OF

    1 A 21
    2 B 45
    3 C 65
    4 D 34
    5 E 12
    6 F
    7 G 89
    8 H
    9 I 34
    10 J 36



    Pivot Table
    Bottom 5
    Row Labels Sum of ***
    A 21
    D 34
    E 12
    F 0
    H 0
    I 34
    Last edited by scareycarey; Aug 4th, 2019 at 03:52 PM.

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
  •