Aggr in Listbox

[idogridish2]

Hi All,

I have a pivot table that display trands,

with two calculated dimensions "Overall Trend" and "Last Two Qtr Trend"

I am using bundle info to show pics insted of values,

now the client wants this pics as filters that hew can use on the side,

"Overall Trend" calculated dimension in the table:

=aggr(if(sum(AttentionFlag)>=2,Only({$<Alabet={'a'}>}info(Alabet)),Only({$<Alabet={'b'}>}info(Alabet))),[Father Supplier Name])

"Overall Trend" calculated dimension in the listbox:

=aggr(if(sum(AttentionFlag)>=2,Only({$<[Father Supplier Name]=,Alabet={'a'}>}info(Alabet)),Only({$<[Father Supplier Name]=,Alabet={'b'}>}info(Alabet))),[Father Supplier Name])

the calculation in the listbox keep excluding the other picture,

See th Attached.

help is appreciated.

thanks.

[sunny_talwar]

I think you might have missed my second post. Try this:

RangeSum(If(Sum(AttentionFlag) = 0 or Sum(AttentionFlag) = 1, 100000, 200000), ORD(Only({$<[Year-Qtr-Num]={'$(=max([Year-Qtr-Num]))'}>} AttentionSign)))

[idogridish2]

Again thank you all,

i managed to solve this one with a simple if:

RangeSum(If(Sum(AttentionFlag) = 0, 100000, if(Sum(AttentionFlag)>2,200000,Sum(AttentionFlag)*100000)), ORD(Only({$<[Year-Qtr-Num]={'$(=max([Year-Qtr-Num]))'}>} AttentionSign)))

Many thanks.

[sunny_talwar]

Or just this:

RangeSum(If(Sum(AttentionFlag) = 0 or Sum(AttentionFlag) = 1, 100000, 200000), ORD(Only({$<[Year-Qtr-Num]={'$(=max([Year-Qtr-Num]))'}>} AttentionSign)))