G
Guest
I have a very simple calculated item in a time dimension of a pivot table (Q1
= Jan+Feb+Mar). However because a lot of the data is has null values my
calculated item returns a zero value which increases the number of rows in my
pivot table by 10 times. Anyone know how I can either not show these zeros or
return a null value when the item is calculated? Thanks Tim
= Jan+Feb+Mar). However because a lot of the data is has null values my
calculated item returns a zero value which increases the number of rows in my
pivot table by 10 times. Anyone know how I can either not show these zeros or
return a null value when the item is calculated? Thanks Tim