Display label inside Mekko Chart

[#1]

Hello,

Is it possible to display the Legends/ Labels of the dimensions inside the Mekko Chart instead of having the legends list separately?

Thank you very much in advance!

[#2]

Attached the example application.

[Nicole-Smith · Accepted solution]

See the attached.

This should give you everything you want.  The only thing you lose is the axis being formatted as a percentage.  I don't believe you can get around this because on the Numbers tab, the expression must be set to Default or it will not display the label.

[#4]

Wow, you are a genius!

I had tried using it with Dual, but i guess it was not the right format.

Thanks a million!

Regards,

H

[#5]

Hi Nicole,

I have another minor problem. Actually the sales data is in number format. I need to display a relative percentage. I tried with using an aggr, but its buggy.

Ideally in the mekko chart it would be good to have the label: number : percentage.

Could please have a look? Do you think its possible?

Thanks again!

[Nicole-Smith]

Like this?  (See the attached.)

[#7]

Something like this, but the Total function doesnt take into account the dimensions, right?

As the Total has to be by MediaType. That's why I was trying the AGGR, but it doesnt calculate for all the lines!

[#8]

The question is how to formulate the expression so that it functions like the relative function works for the expression.

[Nicole-Smith]

Like this?  (See the attached.)

[#10]

Yep exactly, had figured it out, and it also works using aggr(nodistinct

sum( ....))

Thank you anyway!

Regards,