T
Tobias
Hello, I am experiencing a strange thing in my pivottable.
I have a list from which I generate my pivottable, that consists of other lists compiled and transformed to fit my pivotlist. One of the lists that are transformed are built up with =IF(Handle!D3="";"";Handle!D3), to remove all the zero values. The other lists have no zero values (no formulas).
Anyhow the data taken from the list with the if-formula shows zeros when I generate the pivottable. (the other pivotdata only show value when there is a value). The strange thing is that the list from which I generate my pivottable has only values -no zeros.
Tobias
I have a list from which I generate my pivottable, that consists of other lists compiled and transformed to fit my pivotlist. One of the lists that are transformed are built up with =IF(Handle!D3="";"";Handle!D3), to remove all the zero values. The other lists have no zero values (no formulas).
Anyhow the data taken from the list with the if-formula shows zeros when I generate the pivottable. (the other pivotdata only show value when there is a value). The strange thing is that the list from which I generate my pivottable has only values -no zeros.
Tobias