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.

Thanks,

Chris Heathcote

Accepted answers

All comments

rob_marshall

@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

ChrisAHeathcote

@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.

Chris

rob_marshall

@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

ChrisAHeathcote

@rob_marshall

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

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…