Aggr over class with variable

[Tim_G]

Hello there,

I am trying to aggregate over a class which depends on a variable, such like this:

aggr(nodistinct SALES, PRODUCT_LEVEL, class(PRODUCT_PRICE,$(v_PRICERANGE)))

The values should be shown in a simple table. Aggregation on PRODUCT_LEVEL works fine. But I further want aggregation on Price Categories which I set with a variable which is chosen via a slider. The variable works fine for other visualizations, such that I suppose there is a problem with aggregation on classes or variables respectively.

Other board discussions did not help. I would be greatful for any advice.

[jbhappysocks]

Hi

You don't need to use aggr, just use 

class(PRODUCT_PRICE,$(v_PRICERANGE)) as dimension

and sum(Sales) as measure

[Tim_G]

Hi,

thanks for the reply! However, this is not quite it. Maybe I did not explain it properly.

I also have PRODUCT as the lowest dimension and for each PRODUCT I want to have sum(SALES) in its specific PRODUCT_LEVEL and PRICE_RANGE. So I thought aggregation over the dimension would be the way to go.

Like this:

Maybe I am on the wrong lane here trying to solve this with an AGGR function. But for PRODUCT_LEVEL it works.