LastWorkDate with set analysis

[carlos13]

If I can help make this set analysis that does not work me.

Sum({$<dateperiodo={$(=LastWorkDate((dateperiodo-32 ) ,1 ))}>} Monto).

if I select the date: 31/01/2014

I want to get the date 30/12/2013 and sum Monto

Thanks and best regards,

[Gysbert_Wassenaar]

Try using a variable. See attached qvw. You might need to make sure that the variable returns the value in the right date format by using the date() function.

[carlos13]

not work, if you can help me.

Thank.

[Gysbert_Wassenaar]

It does work. Select 31/10/2013 instead. You'll see that your table will show a row for 30/09/2013. It's simply that your table doesn't have any records for 29/10/2013 so if you select 30/11/2013 you wont get a result.
BTW if you want both values displayed on the same row you'll have to remove the dimension from the straight table.