2 Replies Latest reply on Nov 25, 2016 2:43 AM by Simon Runc

# i want show the highest % value should be in Larger size

Hi All,

I have do nut chart,in that chart i want display my highest % value should be in Large size.

how to do this,can you please explain.

Regards

Mallikarjun

• ###### 1. Re: i want show the highest % value should be in Larger size

Put your Highest % measure on Angle.

Mahfooj

• ###### 2. Re: i want show the highest % value should be in Larger size

hi Mallikarjun,

So one way to do this is to create 2 labels, where one only shows if the %age is the largest, and one for the other values. We can then place these side by side and make the largest ones bigger...

So first I create the calculation for the Share

[Share of Total]

SUM([Sales]) / TOTAL(SUM([Sales]))

Then I create a Label calculation which only returns a value for the largest one...

[Share of Total - Max]

IF [Share of Total] = WINDOW_MAX([Share of Total]) THEN [Share of Total] END

with no ELSE condition...it returns NULL for all but the MAX one

I then create a Label for the rest

[Share of Total - Others]

IF [Share of Total] < WINDOW_MAX([Share of Total]) THEN [Share of Total] END

and then finally we can bring both onto the Label shelf and arrange the label (in Edit) like the below

and we get something like this

Hope that makes sense and is what you were after...let me know if not (on either front!)