Top N Chart with 2 Series

[chris777]

I have a report with a stacked line graph in the report header. The data axis is displaying a count of Widgets sold. The group axis shows by date (day) with a separate series for each sales rep. I tried adding a Top N to the second group (sales reps) but it doesn't work.

Here is the troubleshooting I have done so far:
1) If there is only one group a Top N works fine.
2) A Top N on the first group works fine.

The problem only occurs when the Top N is applied to a second group (creating multiple series). I only want to see the Top N series, by day, count of sales.

Is this a bug or a feature?


Chris
Data Intelligence Group

http://www.digus.com

 

[lbass]

I just tested this in XI, and the topN worked fine on the second series, in your case, sales reps. My chart shows the top 3 sales reps (out of 6 total) per day. What version are you using? And is this what you expect to see?

-LB

 

[chris777]

Sorry, yes I am using XI. I must be doing something wrong that I am not seeing. I'll go back and do some testing. Thanks for validating it's not the product.



Chris
Data Intelligence Group

http://www.digus.com