Top Level Item Filter to Show Subtotal

Monpero

Hi All,

I have a module with a composite hierarchy below. I would like to filter with a boolean line item for all countries in the Americas and get their total 50 show in the ALL Regions (Top Level Item).

Also when the filter is applied I want the ALL Regions (Top Level Item) to show in the list items.

How can I achieve this?

Filter Module

When filter is applied I get the total for all items in the hierarchy

Instead I want this total to show

Please any idea or suggestion will be helpful.

Dikshant

@innocent @Saiteja66,

I got a workaround to only show selected sums at the top levels within the same input line item. Consider this example: employees roll up to the department, and in the employee module, we are storing active employee Boolean. The requirement is to only sum up the data for active employees at department and total department levels.

1) Create a line item called Active Amount and write the formula. Set the summary to SUM.

Active Amount: IF Active? THEN Amount ELSE 0

2) Create a line item called Dept Totals, refer Active Amount line item, set the summary to SUM, and apply Department list as dimension within same module.

3) Create a line item called Denominator, formula as 1 and remove the dimension. Set summary of Amount line item as Ratio with Dept Totals as numerator and Denominator line item as denominator.

Sharing the screenshots:

Hope this helps.