I can't seem to figure out where my mistake is. Did I miss adding a list within the hierarchy or is this simply an error within the blueprint?
@Bjackson
In your blueprint (your 2nd picture), the line item summary is set to None.
Due to this, summaries will not happen which is why when you look at Americas, everything is blank.
Rob
I feel as though I'm making this more complicated that it is! I made the change (result photo one) and yet and still the data does not show results (photo three).
You need to enter your formulas and turn the summary back to None.
I was able to resolve the issue. I understand your reference to the Pivot now, there is where I had to switch G2 to Columns and Line Items to Rows! Thank you, again!
Change your pivot from Americas to a detailed member. Since your summaries (at the line item level) are turned off, data will not aggregate up.
@rob_marshall, I don't recall this being explained within the building instructions. Can you provide more detail on where this option is located?
I’m having trouble recovering access to my Anaplan workspace account. Could you please help me?
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…
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…