Skip to Content
0
Former Member
Sep 22, 2016 at 09:30 PM

Calculating for "All Others"

73 Views

Hi everyone.

I have an interesting requirement I've been working through trying to figure out for a while now.

The requirement has a set number of tables based on 6 dimensions, some have ranking of the top 10 plus input controls to further filter by.

They want to sum the table columns results plus add an "All Others" summation of the rest of the values outside the ranked filter.

I've done a formulas like: sum(nofilter(<balance>;drill)) - sum(<balance>) etc.

I really like to ask for a hand of the requirement with the formula or if another path to consider as well.

ps.

BOBJ 4.1sp6

report off a bex query

Thanks all.