0 Replies Latest reply: Oct 19, 2017 4:56 PM by Andres Garcia RSS

    How to obtain correct result of a %

    Andres Garcia




      I am trying to obtain a percentage of a monthly data. The correct results should be obtained from 2 different tables.

      To do that I used the following Expression:






      If I used the dimension from The first Table I got On result, If I used the dimension from the second table I obtain another result.


      Basically when using the first dimension It counts the correct data, based on the first expression, but the second expression counts all data as a single number for every month.


      How can I do so each of the expressions counts based on different dimensions?

      Or Is It possible to use some sort of conditional dimension like if I user the first expression use one dimension dimension and when using the second expression use the other dimension?