Bar Chart Issue

[MRitter]

I want to display the following in a bar chart:

Total sales for the TopN (will use a variable to control this) customers by quarter.

I have tried the following expression and it works fine if I select a single quarter.  But when I display all quarters the totals are not correct.

=aggr(Sum({<[End Customer Global Ultimate ID] = {"=Rank(Sum([Product Bookings Ttl]))<=100"}>} [Product Bookings Ttl]),[Fiscal Quarter ID])

[Vegar]

Do you need the aggr()? If not then try

=Sum({<[End Customer Global Ultimate ID] = {"=Rank(Sum([Product Bookings Ttl]))<=100"}>} [Product Bookings Ttl])

If you do need it then you might want to put a sum around the lot like this:

=Sum(aggr(Sum({<[End Customer Global Ultimate ID] = {"=Rank(Sum([Product Bookings Ttl]))<=100"}>} [Product Bookings Ttl]),[Fiscal Quarter ID]))

[MRitter]

Neither one is working.

I have a straight table which shows the Top 100 customers for a quarter and the total is 487,373

In the bar chart if I filter on just this quarter I get the same amount.  However, with no filter the total for this quarter is only 340,347.  All quarters are off.

What I ultimately want is for the bar chart to show the total sales for the Top 100 customers in that quarter.