Top Ten and All Other

[bapaul]

Hi.  I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales.  How can I make a row to show 'All Others' so I can foot the lines to the total sales?  I've tried a CVR calc but it pulls in the top customer only.

Thanks,

Brian

[JackLacava]

Can you post the definitions of the rows in question, please?

[bapaul]

This is my first line that brings back the top ten (U5 is my Customer field):

U5#Top.CustomMemberList(BRName = CustomerRank, MemberListName = Ranked, RankType = Top, RankCount =  10, LoopMemberFilter = U5#root.Base, DataCellToRankMemberFilter = Cb#CustomerData:E#|CVEntity|:P#|CVParent|:C#USD:S#|CVScenario|:T#|CVTime|:V#|CVView|:A#Sales:F#|CVFlow|:O#Top:I#Top:U1#|CVUD1|:U2#|CVUD2|:U3#|CVUD3|:U4#|CVUD4|:U5#|CVUD5|:U6#|CVUD6|:U7#|CVUD7|:U8#|CVUD8|)

And my second row for total sales is:  U5#Top:Name(Total Sales).

So I'm looking for a single line that is essentially...total sales -  sum of the top ten results.  I'm sure it's something simple.