none
Suppressing "0"s in pivot table total

    Question

  • Hello Guys,

    Who has experience to eliminate the records with total euqal 0 in pivottable? This is a requirement our customers requested because this feature is avaialbe in cognos report.

    My pivot table is against a tabular cube. (Excel 2013+SQL2012 Tabular)

    E.g.

    SchoolName     CostA    CostB     GrandTotal

    AAa                  10         0              10

     BBB                 0           0               0

    CCC                  10         10            20

    They do expect not to show the reord of "BBB" because the grandtotal is 0. Any idea on this?


    Derek


    • Edited by Derek Dai Friday, November 08, 2013 7:49 PM
    Friday, November 08, 2013 7:49 PM

Answers

  • Hi Derek,

    You could apply a value filter by right-clicking "BBB", selecting Filter -> Value Filter...

    Then select "Show items for which Sum of CostA is greater than 0".

    Best regards,
    Daniel

    • Marked as answer by Derek Dai Friday, November 08, 2013 8:36 PM
    Friday, November 08, 2013 8:22 PM

All replies

  • Hi Derek,

    You could apply a value filter by right-clicking "BBB", selecting Filter -> Value Filter...

    Then select "Show items for which Sum of CostA is greater than 0".

    Best regards,
    Daniel

    • Marked as answer by Derek Dai Friday, November 08, 2013 8:36 PM
    Friday, November 08, 2013 8:22 PM
  • Thanks so much!

    Derek

    Friday, November 08, 2013 8:36 PM