Aggr Issue

[cmorri1988]

Hi There,

Does anyone have a solution for the attached image please?

Within my table, I want to show BINDING totals from selections where GENRE is the same as the record within the table.

The image should hopefully explain best.

Thank you!

small test application also attached should it help.

[swuehl]

Are you looking at the min ISBN per genre?

Maybe

=Sum( Aggr( FirstSortedValue( BINDING, ISBN), GENRE))

[cmorri1988]

Thanks Stefan,

Not necessarily the minimum as selection could be any ISBN per Genre.

Can see why my example would make you think that!

Thanks,

Carmelle

[swuehl]

Sum(TOTAL<GENRE> Aggr( BINDING, GENRE))

?

[cmorri1988]

Perfect, worked wonders!!!

Much appreciated!!