sum(aggr(max)) with set analysis

[geogou1973]

Hello.

I have the following expression

sum(aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and in dimension the field COMPANY_NAME_HOURLY_CURRENT

How can i write this expression if i don't use dimension and i want to have results only for the COMPANY_NAME_HOURLY_CURRENT='01' in a chart.

Thank you in advance.

[MK_QSL]

May be

sum({<COMPANY_NAME_HOURLY_CURRENT = {'01'}>}aggr(max({<COMPANY_NAME_HOURLY_CURRENT = {'01'}>}RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

[geogou1973]

Unfortunately the result is 0,00

[MK_QSL]

Provide sample data or sample app.

[geogou1973]

I want to SUM the MAX(RETAIL_HOURLY_CURRENT) by DATE_ID_HOURLY_CURRENT,

                                                                                    COMPANY_NAME_HOURLY_CURRENT,

                                                                                    ZAP_CODE_HOURLY_CURRENT

for the COMPANY_NAME_HOURLY_CURRENT='01'

and i want to do this without a field dimension only in expression just a number