Forum Discussion

bapaul's avatar
bapaul
New Contributor
2 years ago
Solved

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 line...
  • jzook's avatar
    7 days ago

    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