Charts - Display Top Percent and Legend Layout Questions

[Former Member]

I have two pie charts with problems. In one, I've set the Options Legend Layout to Both, Top Percent to 85, and the legend displays the top 85 percent with a count for each group, but the total of the count column is still the grand total, not the total of the 85 percent.

In the second pie chart, I have the same settings, Top Percentage and Options Legend Layout Both, but the count displays as dollar values, eventhough the field is a date field.

Does anyone know how to correct these problems?

Thanks!

Robin

[Former Member · Accepted solution]

I had the issue with dollar sign in the legend before but somehow it was gone.

On the issue with total count still a grand total, can you specify what you are using for the On Change of option and Show Values option?

Thanks

Edited by: Sharma Hari on Nov 23, 2009 11:54 PM

[Former Member · Accepted solution]

Boy, wish my dollar values would "go away"! On the On Change, I set TopN toTop Percentage, and the Show Values as Count.

Robin

[JWiseman · Accepted solution]

hello Robin,

the legends can be a pain sometimes as there is not much customization as you know...you can use a crosstab though as a custom chart legend and then you can edit it as much as you wish...check out

for ideas on how to use this method.

cheers,

jamie

[Former Member · Accepted solution]

Hey, I found out how to make the dollar signs "go away." In Options, Data Points, I selected both the Show Label and Show Value, although I only want the labels to display on the pie chart. The dollar signs disappeared, then I deselected the Show Value, and it remained as a non-currency number.

So does anyone know how to get the Top N to total only the top percent and not the complete total?

Thanks!

Robin

[JWiseman · Accepted solution]

hi Robin,

you've got 2 options:

a) you can use the cross-tab method that i mentioned before...a top N in the cross tab will show a percentage that is based on the whole record set as opposed to the N values...this is different than the chart legend percentage

b) if you are willing to show the percentage that is based on the whole record set in the chart labels instead, you can do the following...

if you have an On Change Of value of "country" and the summary is "sales", then create a new formula called "chart title" that has syntax similar to

{Customer.Country} + chr(10) + totext(PercentOfSum ({Customer.Last Year's Sales}, {Customer.Country}))

now change the chart On Change Of to your new formula. the percentage based on the whole record set will be shown in the chart labels.

cheers,

jamie

Edited by: Jamie Wiseman on Nov 25, 2009 1:34 PM

Edited by: Jamie Wiseman on Nov 25, 2009 1:35 PM