Trying to Limit Charts to the Bottom 10 Accounts

  • I have a report that displays a lot of look up data. I then added a ranking column to show the bottom 10 accounts. I have to 8 charts that should display the issues placing these account in the bottom 10. I have the chart grouped by Customer Number. I have 2 filters on the group. 1st units on contract >=10. 2nd is the ranking formula looking for the bottom 10.

    A specific issue is credits; 3 of the accounts don't have credits written against them. The charting pulls the next 3 accounts with credits outside of the bottom 10.

    I need the charts to just display for the bottom 10 accounts.

  • I resolved the issue by rewriting my queries with case statements.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply