Hi,
Please can anyone show me how can I use a summary method but include only items that are visible after using a filter.
Thanks in advance
Hi @Ikrame
You would have to create another line item that shows filtered data only. You can use a formula like this - "If <filter condition> then <source data> else 0". Then the summary of the newly created line item will show you the sum of filtered items.
However, if your filtering is by user dimension, then this module will also need to be by user dimension and will tend to increase in size.
@Ikrame
Summary Items are applicable to all of the items, it doesn't work selectively or on filters.
Thanks,
Misbah
Miz Logix
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
