I have created a pivot table computing the average of age. When I use old data source (no missing), it works, but when I use a new data source including missing values, it gives error like #DIV/0. Does anyone know how to let pivot forget missing data, only calculate on the existing ones.
Thanks
Thanks