1 Reply Latest reply: Nov 25, 2016 2:15 PM by Sunny Talwar RSS

    Link table using set analysis

    Damian Aberbuj



      I have following model:


      $KeyFechaTicket is a key from master calendar and it has a comparative date 1 year before.

      For example: 15/11/14 vs 16/11/13....03/03/16 vs 20/03/15....


      I want to sum "Cantidad Items" using %KeyFechaComparación = [Fecha Ticket]. I try doing it using the following expression but doesn't work:

           sum({<%KeyFechaTicket=, [%KeyFechaComparación] = {[Fecha Ticket]} >} [Cantidad Items])


      Anyone can help me?...