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.
report off a bex query