nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Totals with dynamic cell access

kleadbeater1

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

Anaplan workspace account
I’m having trouble recovering access to my Anaplan workspace account. Could you please help me?
Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…