Hi,
I need to pull period data from one module to another but the only dimension that is matching is time. What formula can I use?
Not much information to go off of here, but it really comes down to the relationship between the other dimensions (the ones that aren't Time), and what you need to accomplish. Most of the time, this is going to end up being a SUM or a LOOKUP, so I'd recommend reading through those function pages, or post some additional information or screenshots of your blueprint if you can.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
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…
