Ability for summaries to only include the items which are visible after filtering

Details of Enhancement:
Enhance filters on a dashboard to update totals and subtotals in summary rows - when a filter is applied, the subtotal should update to sum only the filtered records

How this would help their business process:
When users see a filtered view, or adjust a filter, subtotals and totals can be misleading / not correctly represent what is on the screen

Comments

AnaplanIdeas

Status changed to: In Review

rhernandez

this is a great Idea and a mus to have

Rebecca

This requires some considerable changes to the fundamentals of our calculation engine and has quite a high cost. We need to see more demand before we can add this to the roadmap and start work on this.

stitto

'Summaries for filtered items' is also one of the requirements I faced. I would also very much appreciate this feature.

andrewtye

It's a heavy calculation workaround but often go with if not filter then Y else X as there's often more false than true.

But having it properly in the engine a bit like subtotal(9,[filter range]) in Excel would be very beneficial.

chrised209

I'm very much in favor of fixing this, and given the default functionality of displaying summaries on filtered grids without making it obvious to the end user that a grid is filtered (let alone how) and we have the potential for some very serious misunderstandings in reporting.

I'd assert that this needs to be at least band-aided with one or more of the following lighter-weight interim changes ASAP:

A. Do something (Shading/italicizing/etc.) to the dashboard grid / export output to indicate that a filter is present and that summaries may not be reproducible solely from the data reported. Sensible approaches that come to my mind (by no means a comprehensive list, of course):

1. Italicize the summary values on the dashboard grid

2. Append an asterisk to summary values in the grid or export file

3. Bold the borders of a dashboard grid to give a visual cue that a filter has been applied.

B. Lock out display of summary values whenever a filter is applied that changes the number of cells that would contribute to their respective calculations (i.e., no need to lock out calculations for filters that don't touch a relevant dimension, e.g., Current User).

Saptarshi_Sengupta

A Subtotal like function in Summary is really what I am also looking for

svenkova

Definitely makes sense to have this functionality

tomgilbert

This would be very helpful

DCLCRA

This is a hot topic amongst our end users. They are excited to have the filtering option now but are frustrated by the fact that the subtotals don't change with the filters. The inability to have subtotals that change and related only to what is shown on the card after filtering impacts the accuracy and quality of the reporting. A change to this logic would be extremely helpful and welcome.

Abdulgafur

If we have ability for summaries to only include the items which are visible after filtering, it will be a big benefit to the users. Currently due to this functionality not available, it reduces the user freindliness /flexibiity of the system. Need some solution on priority.

Quick Links

New ideas

Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.
A function that identifies all saved views which filters are broken
I would like the function to identify all saved views which filters are broken(error).
Add feature to “Use Account Style Drilling” in AnaplanXL Grids
This feature to display children above the parent when drilling in is available in AnaplanXL freeform but not grids. This would be a useful feature in Grids as well. As a user, I would expect to have same/similar functionality between Grids and Freeform.