0 Replies Latest reply: Feb 20, 2017 5:00 AM by Aviad Bein RSS

    Conditional Display and "Other" aggregate issue

    Aviad Bein

      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