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

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

software

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