Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
aviadbein
Contributor II
Contributor II

Conditional Display and "Other" aggregate issue

Hi all,

Iv'e got some peculiar issue with the Conditional Display that I would be very grateful if someone could help me with.

I've got DB of 1 table with 3 Fields (Attached): Cust (String), A (Numeric), B (Numeric). and the following Inline table:

CondQ1.png

In the app I created a variable (vAmountType) in order to make the Conditional Display:

CondQ2.png

In the app there is a Donut chart with Dimension = Cust and the following conditional Measure (Amount):

CondQ3.png

Now, for the problem:

CondQ4.png

As you probably notice, when i choose to limit the Dimension to TOP 10 with "Show others" and choose the Conditional Display Field as AmountType=1, the top 9 field values are display the correct data - sum(A),

but the Others Value, that is calculated on measure: Amount automatically, Display the incorrect aggregated data - sum(B).

What I did wrong, and why the condition in the variable/calculation is not persistent and change by himself in Others view?

Thanks in advance,

Aviad

0 Replies