5 Replies Latest reply: May 21, 2015 12:35 PM by Julian A. Ortiz Villada RSS

    Show dimension and expression by a field value

    Julian A. Ortiz Villada

      Hi all.

       

      I have this data

       

        

      VendedorValor
      A10
      B10
      C15
      D20
      E30
      F40

       

      And one aditional field named Val, with values:

       

      Val
      10
      20
      30

       

       

       

      I have a straight table with one calculated dimension

       

      If(Aggr(Sum(Valor),Vendedor)<=Val,Vendedor)

       

      And one simple expression

       

      Sum(Valor)

       

      The idea is that the results are displayed depending on the selection on Val field. But where such selection is made, the results are not as expected. for example, when the value is 20.



       


      But, if change the dimension to a hard-coded value, e.g. If(Aggr(Sum(Valor),Vendedor)<=20,Vendedor), it works fine.

       

      Any suggestions?

       

      Thanks in advance.

       

      Julian