Creating a Percent Range for Selection

[benvatvandata]

Hi,

I have a chart that looks something like this:

Customer    ItemCode    Customer Item Qty    Customer Percent %    Total Item Qty

1                    1                                100                        1.01%                        9,900

23                  1                            1,000                      10.10%                        9,900

2                    2                    12,400,000                      74.22%                16,708,000

3                    2                      4,308,000                      25.78%                16,708,000

4                    5                      8,840,000                      50.02%                17,673,000

etc.....

Expressions:

Customer Item Qty: =SUM( OrderedQty )

Customer Percent %: = [Customer Item Qty] / [Total Item Qty]

Total Item Qty: =SUM( Total <ItemCode> OrderedQty )

I want the slider object to be a percent range 0% - 100% (1/4 intervals) that allows the user to filter the chart based on the range of percentages selected

For example:

      0%      25%    50%      75%    100%

<-----|----------|----------|----------|----------|----->

If the user selects range 25% - 100% then only the last 3 rows of my example should display.

I have tried using max and min variables with set analysis, but haven't been able to figure it out.

Could someone please explain how to do this?

Thanks,

Ben V

[benvatvandata]

Oh sorry I didn't see your attachment in your message!

Wow those expressions are a handful... hah, this is getting closer, however when I filter 25%-75% the total displays 0 for the Total Item Qty.

Any other ideas?

Thanks,

Ben V