aggregate aggravation

I simplified my model a little bit here and left out the Unit ranking, but here is the report:

See how it says First in front of my Fields because I'm forced to pick an aggregate I want my report to not have that in front of the field names.  It makes the column names very wide and with 130 stores I really don't need to make the report harder to read.  

This was working without the aggregation/aggravation just 2 days ago, but I originally built it using the January version of the Desktop.  

The query just brings in the data promotes the header to columns and it trys to do typeconversions, but I remove them since I want them all to be Text and Do Not Summarize.  I then add the Rank$ Column with this:

Rank$ = VALUE(AggregationAggravation[ChainSalesDollarsRank]) + VALUE(AggregationAggravation[ProductID4Join])/1000000000 and set the Sort By Column on ProductID to this new column.

And here's the sample data used here:

ChainSalesDollars,ChainSalesDollarsRank,OnHand,ProductID,ProductID4Join,Sales$,SRank$,StoreName
50.00,1,0,123456789 Firstbestsellerinchain 86,123456789,50.00,1,0000-Chain
20.00,2,0,223456789 secondbestsellerinchain 10,223456789,20.00,2,0000-Chain
10.00,3,0,323456789 Thirdbestsellerinchain 12,323456789,10.00,3,0000-Chain
50.00,1,0,123456789 Firstbestsellerinchain 86,123456789,5.00,3,0100-Dallas
20.00,2,0,223456789 secondbestsellerinchain 10,223456789,6.00,2,0100-Dallas
10.00,3,0,323456789 Thirdbestsellerinchain 12,323456789,7.00,1,0100-Dallas
50.00,1,0,123456789 Firstbestsellerinchain 86,123456789,1.00,2,0020-Chicago
20.00,2,0,223456789 secondbestsellerinchain 10,223456789,2.00,1,0020-Chicago
50.00,1,0,123456789 Firstbestsellerinchain 86,123456789,30.00,1,0101-Seatle
20.00,2,0,223456789 secondbestsellerinchain 10,223456789,0.50,3,0101-Seatle
10.00,3,0,323456789 Thirdbestsellerinchain 12,323456789,1.00,2,0101-Seatle