How can we implement Tableau Fixed LOD style calculations in cube

**Problem**

We are trying to implement a Tableau Fixed LOD style calculation where the numberator or the denominator stay constant and only interact with defined filters.
In cube we are trying to do that with a combination of pre aggregations, multi stage, exclude and keep only tags but are not getting accurate results.
We want to understand if there is any other was we can implement that with cube.

No files, tests, or entry points are identified. Start by reviewing Cube's pre-aggregations, multi-stage, exclude, and keep-only tag approaches against the described Tableau Fixed LOD behavior. Done would require a decided implementation or documented supported approach with accurate filter interactions.

Written by the indexing model from the issue text.