Totals with dynamic cell access

How can I get list hierarchy totals to display when using dynamic cell access? For example months are displayed but not quarters or years.

Accepted answers

Tiffany.Rice

Hi @kleadbeater1

I would suggest checking the summarization method on the Boolean formatted line item that is being used as the dynamic cell access driver. By default Boolean lines have a summary method of none, meaning quarter and year totals would not be marked True (thus no access). Ensure time summary is set to All or Any depending on your use case.

All comments

Tiffany.Rice

nathan_rudman

Tiffany gives you the right answer.
I'll add that most of the time, DCA is used to block inputs, not controls who sees what. In which case you can use a generic line item, without dimensions, set to TRUE, as your READ driver, eliminating these kind of issues.

kleadbeater1

That fixed it. Thank you.

Quick Links

Can you help?

Unanswered questions

RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…