Drill through on total

[zane.baranovska]

Hi @Camille,

Thank you for the suggestion! The Total row is quite robust with the primary purpose of showing aggregated results regardless of chosen metrics and dimensions and with no option to interact with it. I am sorry, but we at eazyBI do not plan to add interactions for the Total row or Total column to avoid confusing situations when several metrics are selected for the report.

We suggest using calculated members or hierarchy levels to show Total or Sub-totals in the report. This approach has several benefits:

• users can interact with the results, drill through issues, or drill across some specific dimension: Interact with report
• You can apply the cell formation to those values and highlight extremes and specific values or give a column / row a background color of your choice: Conditional cell formatting.

More details on calcauted members and how to make described here: Calculated members in other dimensions.

Please see those community posts for some use cases:

How to reference, count, and Sum *Only* the Sprint(s) present in Pages drop-down

Hi @daveaust, A higher hierarchy level or calculated members is recommended way to get sub-total or aggregated value. But this is not going together when a dimension is also on report pages and used as a multi-selection filter. In this case, consider working with sprint boards on report rows and pages. When more details are needed, the user can interact with the report and expand the board to the sprint level. [Sprint results aggrgated by boards] Another option is to create a new calculated…

Count of Rows as a Break Line

HI @RichWolverton, My recommendation would be to create a dashboard and add separate reports per organization. So essentially, you will create one report and have the “Organization” page filter set. Then save it for the organization. Then, you would create a copy of the report with the different organization in the filter. Finally add all the reports into a dashboard. Eli Solutions

Best,
Zane / support@eazyBI.com