Hi, folks. I am trying to accomplish a Pie Chart graph in ReportNet. Let's say I have 50 states and each state has a dollar amount. The Pie Chart report should display the top 10 states based on the descending sort on dollar amount and then put the rest 40 states in a Others bucket. How to do it?
Thank in advance!
(I'm assuming you already know how to do "top n" - if not post back and I'll give more details)
Instead of a filter like "rank<11", add a calculated data item to your query which contains something like:
if (Rank<11) then ([your_state_column]) else ('Others')
and use this calculated item instead of [your_state_column]
Steve
can you explain how to do "top n"?
Many thanks
Fedix