Advanced aggregations

[#1]

Hello,

Can somone give me hints on advance aggregation?

i m using in a pivote table Sum(All <myField> amount) but it is giving me syntax error i want to consider the my filed dimension.

[#2]

Try this aggr(sum(amount)myField) hope this helps...