Hi all.
We're developing a solution y which the final analisys of
the data is through a Pivot Table in Excel which
represents data in percentages. We managed to have the
pivot table working on Excel 2000 but when we used Excel
XP the percentages are lost in some situations (showing
then '#VALUE!').
They are only lost when we filter the data picking only
some values of the fields, but not when we select the 'All
[field]' option.
This is becoming very frustrating because we thought the
percentages were allways calculated in the cube so ?why
does changing the client affect the results?.
I'm not sure if the explanation above is very clear but i
need some help with this issue asap.
Thanks
Alejandro Mezcua