Aggr and selections

[#1]

Hi eveyrone,

Is it possible to by pass the selection for the aggr function ?

My example is simple :

My first table ignores the selection with a set analysis

In my second table, I do the same, but with the aggr function, the selections is active

I want to use the aggr function because i have another calcul with the rank function in my application.

Someone can help me to by pass this problem ?

Thanks

[#2]

(To be precise, I want that my table 2 ignores the selections)

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Try with this expression in table 2 instead

Only({1} Aggr(Sum({1} SALES.SALES), TYPE.PRODUCT_NAME))

Hope that helps.

Miguel

[#4]

thanks ! it works!