Pivot Table, average expression and Sum

[shayraber]

Hi all,

I have a two dimensional pivot table, one positioned vertically and the second one (months) positioned horizontally.

the expression is a simple "Avg({<...>}....)". the option of partial sum returns an average of the values (as the expression itself). is there a way of implementing a partial sum which return a SUM of the average values?

for example, the partial sums will return 10 (as the average of a series of 10s) instead of 100 which is the sum of ten items with the value of 10

item	Period
a	10
b	10
c	10
d	10
e	10
f	10
g	10
h	10
i	10
j	10
Total	10

[lironbaram]

hi

you can do it using aggr function

something like , sum(aggr(avg(),Item,Month))

[jafari_ervin]

This attachment maybe useful.