close

I have a Pivot table and it has a calculated ITEM (not field). Ever since I
added the calculated item to the pivot table, it now displays all records
even for those records that have zero values for the calculated item. Before
I added tha calculated item, the pivot table was only showing records with a
calculated value.

The help in Excel said to use field settings etc but this doesn't seem to
work for calculated items.

Any help will be appreciated. Thanks.

Pele

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()