I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
Yes, we need to have dynamic summary totals that adjust based on filters and selective access. To work around this, we have to create new modules and line itmes that create redundancy and inefficiencies in the model. In some cases, there is no way to work around this issue and sumary totals must be hidden. This is a major issue for my clients.
This is definitely a major improvement to the grid that is requested by almost all my customers.
This is also a major issue for my customers. Many of them have requested a total based on what they can see through filters/selective access.
Does this exist? I find it extremely painful that this basic functionality is not intuitive.
This would save so much time and is useful for most customers
Hello, is there any update on when a solution will be implemented?
I've been asking this since we started with Anaplan in 2021
YES PLEASE !
I think as the hyper-block calculates the summaries at the dimensionality this is not possible (I.e. the list items are summed up at their parent level and the filter is just a view/cut of this).
The only way I could suggest doing this is to create a Subset of the list items you want to filter on and then updating that subset with an action. The user can then in effect create a custom "LIST" for their purpose. I hope the below is understandable:
Please note the data in (Table 3) below should be a formula and not data thats been imported as changing the subset removes data (If deselected)
Also if you do set it up as per below the subset would change for all users.
(Although not advisable you can give users access to the the list property that drives the subset and then you wont need the process button)
Description: The new conditional formatting functionality on KPI cards is a welcome enhancement to the Anaplan UX! However, hovering over a conditionally formatted KPI value or status icon displays the underlying conditional formatting configuration, including minimum, midpoint, and maximum threshold values. For dashboard…
I asked Claude to add line items and a formula to a planning model in Anaplan, and it did the job in a few minutes from plain sentences. No special add-on, no clicking through menus myself. That is exciting, and it raises the question every team should ask first: what happens to our data? The short answer is that it…
ADO can handle inbound PGP encypted files (as per https://help.anaplan.com/pgp-encryption-in-pipelines-8f662578-1a51-467b-9817-3083f170511c). However, outbound there seems to not be a solution. Please provide a way to create an encryption key using PGP for files to be provided into a SFTP connection.