Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Attached the example application.
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.
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
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!
Like this? (See the attached.)
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!
The question is how to formulate the expression so that it functions like the relative function works for the expression.
Like this? (See the attached.)
Yep exactly, had figured it out, and it also works using aggr(nodistinct
sum( ....))
Thank you anyway!
Regards,