Remove highest value from chart

[Anonymous]

Hi,

How can i remove the highest value in the chart?

[rubenmarin]

Hi Marius, for just that bar you can try with:

If(Rank(YourActualExpression)>1, YourActualExpression)

If you want remove the dimension maybe using a calculated dimension:

Aggr(If(Rank(YourActualExpression)>1, DimensionField), DimensionField)

[#3]

hi,

top(sales)-sum(sales)

will give u o/p hopw it will help to complete the task.

Thank you,

Balaji.k

[#4 · Accepted solution]

Hi Marius,

One more option you have in Dimension limit, where you can limit the amount as shown below;

I hope it will help you

Regards

[#5]

Its quite simple just use the below syntax removing any value greater than the specific number as shown below based on your requirement

[SatyaPaleti]

Hi Marius,

Here you can option to maintain certain limit

Path --> Chart Properties--> Dimension Limits

Thank you,

SatyaPaleti

[#7]

Hi Marius,

Simple way, U can work on Properties of Object u can choose  Dimension Limits tab then u will have option to restrict the highest value.

Ramya.