Bar Chart With Top 10 Values along with Selected Field

[shabarish0587]

Hi,

Please see the sample data file and screen shot. In data file i have two field one field is Hospital Name and second one is Normalized Paid Amount. In Bar chart i want top 10 hospital Names based on Paid Amount.Please any tell me how to do this.

[vishsaggi]

Use Bar chart with HospitalName as Dim and

= Sum([Normalised Average Cost]) as your expr.

Then in dimension limits tab of Chart properties check like below?

Check Restrict which values and Uncheck Show others as highlighted.

[shiveshsingh]

Use hospital name as dimension and sum (Cost) as expression.

in dimension limits tad, select restrict check box. '

hope this helps

[Anil_Babu_Samineni · Accepted solution]

First of all, In your dummy data you don't have data as TOP 10

May be this in straight table as Dimension

=aggr(if(Rank(total Sum([Normalised Average Cost]))<=3, [Nombre Comercial]), [Nombre Comercial])

Expression is simple Sum([Normalised Average Cost])

And then check the suppress value is null

[shabarish0587]

Thank You Anil

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .