Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can correct this by using the AGGR funciton, you should look around the forum since this has been resolved several times already.
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
Can you post a sample app then? because I don't really understand what your problem is.
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...