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.


Chris Heathcote


  • @ChrisAHeathcote 


    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?



  • @rob_marshall 

    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.


  • @ChrisAHeathcote 


    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.



  • @rob_marshall 

    An idea I can use in future projects but for now it is not a burning priority of the client.