I want to put a period filter like this so that when the user checks the boolean, the data of the months associated with the year will be shown in the below grid.
Need some help with this.
Create a filter module dimensioned with the same time as the module where you want to apply the filter. One line item (LI) with Year format and formula of
PARENT(ITEM(Time))
Call this LI as Year
Another LI. LI format will be boolean and the formula will be
Select Filter Year.Boolean[LOOKUP: Year]
Call this line item as Filter Year
Then in your Employee Expense module, apply the filter in the columns. This is what the NUX view should look like
Add a Users dimension to make sure that user selections do not clash
Thanks, Anirudh!
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…
