My problem is that the partial sum in the pivot table shown me a value "-" (Null) . But I have figures for every rows above it. Also, there are all numbers as well. There are field data from excel file directly. Do anyone have any thoughts?
Another question:
I have used sum(Amount)/sum(total<Field="A">Amount) in my expression. It works fine. And I can get the partial sum of it. But when I use it for further calculation, it doesn't work. For exampl
I have solved that problem by chance. What I had before: Column(1) + Column(2), where Column(1) is the one with long formula, Column(2) is Cash.
They both work fine individually, but not after addition.
What I have done was: demote Column(1) to Column(3). Then use formula Column(3) + Column(2) (Cash has no change). By magic, it works suddenly.
However, I am still working on the problem on partial sum...I have figures one every rows, but partial sum gives me "-".....I am try to change the origin data in Excel from formula to value (hope i can solve it by luck again).
Thanks for everyone's helps. I have solved it. The reason is that data are from from level. Therefore, the expression total in pivot table is not working. To solve it, I have use aggr in my expression.
