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
Can you post the definitions of the rows in question, please?
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.
