Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link table using set analysis

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!

1 Reply
sunny_talwar

Would you be able to share a sample with the expected output to be able to help you out better here.

Best,

Sunny