partial sums in a pivot are wrong

[#1]

hi,

i have a pivot-chart, were are shown some data:

name	date	value
abc	1.1.	17
	2.1.	10
	total	10
def	1.1.
	1.2.

the total field is because of the check-box in presentation-tab, name and date are dimensions, value is a formula.

has anybody an idea to fix the problem?

[danielrozental]

You can correct this by using the AGGR funciton, you should look around the forum since this has been resolved several times already.

[#3]

with aggregeation i can fill a new column with the partial sum, but i don't want to do this.

i used the search, keywords were 'partial sum pivot', but i can't find a solution.

thats why i asked

[danielrozental]

Can you post a sample app then? because I don't really understand what your problem is.

[erichshiino]

Hi,

The aggr expression would be something like:

sum ( aggr ( yourExpression, name, date))

but it may be good to take a look at your expression to understand what is going on...