set analysis expression

[geogou1973]

Hello.

I have some data like

date - store - item - value - discount

Also i have a variable that is the date-1

how can i bring in a chart with set analysis the items that the date is date-1 with the value and the discount > 20 %

Please help

[Gysbert_Wassenaar]

Use item as dimension and as expression =sum({<date={$(vMyVariable)},discount={>0.2}>}1). If that doesn't work, please post a document with example data.