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
Is there a solution to this?
I don't spend much time building Cube Views, but the most obvious option I can think of would be to have the Cube View compute the difference between the TopN and the Total rows, in much the same manner as you would include something like a Variance row or column.
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.
Can you post the definitions of the rows in question, please?
