Results 1 to 16 of 16

Can't hide zero value calculated items in a pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    France
    MS-Off Ver
    2013
    Posts
    8

    Can't hide zero value calculated items in a pivot table

    Hello,
    I need help to find a way to hide zero value calculated items in a pivot table.
    So far I have tried a number of tricks at no result.
    I have a database for CO2 tons emissions for 2021 for a number of scopes and subcategories for some countries and locations.
    I need to compute 2025 estimations by applying a coefficient to some 2021 values.
    I have a done a pivot per rows = Category / subcategory. Columns = Years, E values = Sum of tCO2eq.
    I'm adding two calculated items to the Years field.
    The first is "Coeff" and its formula is "= 1"
    The second is "2025" and its formula is "= '2021' * Coeff".

    As soon as I enter the Coeff calculated item a number of additional rows appear for all categories with "0" values, whereas before only the rows with values would appear.
    I can't find a way to hide the zero values lines.

    Can someone help me ?

    Thanks,
    -Pierre

    30/08/2022 update: the "Coeff" value need to be set on a line per (non zero) line basis in the Pivot (that's why I used a calculated item).
    31/08/2022 update: the "Coeff" value needs to be set on PivotTable row, not per line within Database. e.g. I want to set a 0,6 coeff value on the "Purchased goods and services" row for "COmpany". THat would calculate 2025 CO2 emissions as reduced by 40% and give 442 817 (that is 40% of 2021 emissions as 738 028).
    Last edited by pdecrocq; 08-31-2022 at 10:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with calculated fields/items in pivot table
    By Yustino in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-12-2022, 02:22 AM
  2. Calculated fields and items rules in Pivot Table
    By hristina.trpkova in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2018, 02:22 AM
  3. Hide Select Calculated Pivot Items
    By matt4003 in forum Excel General
    Replies: 1
    Last Post: 08-10-2009, 12:44 PM
  4. [SOLVED] PROBLEM OF ADDING CALCULATED ITEMS TO PIVOT TABLE
    By stas.konovalov@ua.fm in forum Excel General
    Replies: 0
    Last Post: 08-09-2006, 03:40 AM
  5. Calculated Items in Pivot Table
    By Craig in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 08:35 PM
  6. Pivot Table - Calculated Items
    By bchan in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 10:31 PM
  7. Pivot Table - Calculated Items
    By bchan in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 03:00 AM

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