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 )

       

      Example:

      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