Comparing selected week to previous week

[#1]

Hi,

I have a date field (Salesweek) and few other KPI's. I created listbox for Salesweek and other table chart has KPI's.

When I select Salesweek 8/18/2014 in the list box and my table charts has to show NET KPI for that selected date and a week before data 8/11/2014.

Prod          NET          NETpreviousweek

LAPTOP   $2000        $2500

Is this can be achieved by set expression?

Thanks,

[jyothish8807]

Hi,

try this:

sum({<Date={">$(=Var)<$(=Var)-7"}>}Amount)

Regards

KC