Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Multi-selection behavior when applied in view header (POV)

Today, the view lets you select multiple items from the combo-boxes in the view header.

User can choose between SUM or AVERAGE for aggregation. Measures amounts are calculated accordingly to user's choice.

The same occurs for measures calculated by rules. But it is not the expected behavior. Calculated measures should be calculated according to their definition in cube rules.

Example:

Product Quantity Amount Unit Price (C: [Amount] / [Quantity])

A 100 1000 10

B 50 2500 50

Today, displayed values according to user choice are

SUM 150 3500 60

AVG 75 1750 30


But displayed values should be

SUM 150 3500 23,33

AVG 75 1750 23,33


Rules should be applied even if a multi-selection is made.

  • Guest
    Reply
    |
    Feb 27, 2025

    One way of solving this problem would be to use subsets with a virtual consolidation element. See idea JS-I-1725.