6 Replies Latest reply: Jun 13, 2014 5:16 AM by Maxime Bourg RSS

    Set Analysis

    Marcus Augusto

      To sum some values we use the following function: sum( Value )



      sum( TotalSales )

      But, what to do if you want just view the sales of 2014 ?

      We can use the Set Analysis, then don't need make SQL script.

      Using Set Analysis:

      sum( {<Year = {'2014'}>}  TotalSales)


      This will sum the TotalSales of 2014, without othes years