Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Frnz,
I want Top 5 Sum fot AMID and AMID_ID. I am getting for AMID_ID but not for AMID.
Something wrong, Please help me to find solution.
Please find the attached QVW.
That's because your advanced aggregation is not aware of your AMID filtering in the chart dimension, thus considering 'TTTT' when ranking, but filtering it when matching advanced aggregation dimensions with outer chart dimensions.
You would need the dimension filter also in the inner aggregation (since aggr() function does not allow a calculated dimension):
=sum(aggr(if(rank(sum( {<AMID -= {"TTT*"}>} Sale))<=5,sum(Sale)),YEAR,AMID))
That's because your advanced aggregation is not aware of your AMID filtering in the chart dimension, thus considering 'TTTT' when ranking, but filtering it when matching advanced aggregation dimensions with outer chart dimensions.
You would need the dimension filter also in the inner aggregation (since aggr() function does not allow a calculated dimension):
=sum(aggr(if(rank(sum( {<AMID -= {"TTT*"}>} Sale))<=5,sum(Sale)),YEAR,AMID))
Nice one.