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

    Link table using set analysis

    Damian Aberbuj

      Hi,

       

      I have following model:

      modelo.jpg

      $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?...

       

      Thanks!