bapaul
2 years agoNew Contributor
Top Ten and All Other
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
I have accomplished the "All Other" total using a U8 formula (RankedTotal) that calculates the accumulation of the records but in a corresponding column. Then I used a formula in the original data row to capture that total and perform the calculation. This is used in Conjunction with the golfstream busines rule XFR_MemberListRanked.
https://community.onestreamsoftware.com/discussions/Reporting/cube-view-running-sum/4947/replies/5583