Editing what is visible when drilling down a calculation
Is it possible to edit what can be seen when a user drills down on a cell?
The model has a few complex formulas and the user does not need to seem them but would like to retain the ability to drill down through the different levels of the calculation.
I don't believe so, but possibly create a dummy line item that is just the result of the logic and base the downstream calcs off the dummy?
Interesting idea but the module contains many line items which would need similar treatment.
The value does not exceed the cost and effort to build.
Appreciate the quick response.
Yep, agreed. It is a possible solution, just not a good one if there are many line items with logic you want to "hide". Another possible solution, and it is in line with the previous one, but to have a "reporting" module where the line items are just "dummies". Think of the logic as a CALC module and then you have the reporting module just referencing the calc. Might be too much of a hassle, though.
An idea I can use in future projects but for now it is not a burning priority of the client.0