Aggregating based on a particular dimension in a straight table

[#1]

Hi All,

I have a straight table with dimensions like state, city, distributor and retailers are their and then some expressions are there. Now my requirement is to show one of the expressions based on distributors i.e. the aggregation should be done on the distrbutors and not on the retailers. For every retailer it should show the same value i.e. the total for that distributor to which the retailer belongs to.

[maxgro · Accepted solution]

to evaluate the expression at the distributor level

sum(  total <distributor>  expression)

sum( total <field1,field2> exp)

sum(total exp)

[#3]

Thanks.