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...
Reports
  • jzook's avatar
    jzook
    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

rhankey's avatar
rhankey
Contributor III
5 months ago

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.

jzook's avatar
jzook
New Contributor II
5 months ago

Yes but I cannot get the total of the TopN... in order to calculate that variance.