Block Chart- Average at 1st level and sum at 2nd level

[#1]

Hi All,

I am trying to create a block chart but I want to show the average at 1^st level and sum at 2^nd level. Snapshot below-

Can anyone guide me on this ?

Many thanks

Ashish Koul

[Gysbert_Wassenaar]

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.

[#3]

@ Gysbert

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

Regards

Ashish Koul