As far as I can tell you'll have to use calculated dimensions for that like:
dual(Level1 & ' (' & aggr(avg(Amount),Level1) & ')', Level1)
dual(Level2 & ' (' & aggr(count(Amount),Level2,Level1) & ')', Level2)
and uncheck the option Show Numbers with Labels on the Presentation tab.
comm82423.qvw 197.5 K
Many thanks for the quick response .
Its working fine for 1st level .
In case of 2nd level if anyone from team A and Team B is having same name, then it is adding them up
Also request can you please share any link/tutorial for calculated dimension/ functions like dual , aggr ,etc