Aggregate dimension in some cases

[Anonymous]

Hi,

it's possible to aggregate one subDimension in some cases ?

for example

i have

sales for products ; and products in categories

i want this dimensions

Category

   +ProductName

   +Others (in this case i want sumarize in one condition)

Expressions

   Sum(sales)

   Sum(quantity)

thanks

Ricardo

[sunny_talwar]

May be check this:

The Aggregation Scope

and

What does the TOTAL qualifier do?

[swuehl]

Which products should be included in 'Others' and which should be put separately?

Maybe try something like

=If( Match(ProductField, 'A','B','C'), ProductField, 'Other')

as calculated dimension.