Hi All,
Here is my senario:
I have three tables (which I have attached as spreedsheet with this questions)
Pageview Last Week
Pagewiewed last 4 weeks and
Users
I want to create a list of user and to show the count of page viewed against name and id
which fulfill the following conditions
Pageview count in last week >= 5 and
Pageview count in last 4 weeks >=16 for example
The way I am trying to handle it as created two variable and input boxes and then used these two variables in expression
Variable 1 for sum page count in last week and
Variable 1 for sum page count in last 4 weeks
and the expressions are
SUM ({<PAGEVIEW_COUNT_Lastweek={">$(Variable1)"}>}PAGEVIEW_COUNT_Lastweek)
and
SUM ({<PAGEVIEW_COUNT_last4weeks={">$(Variable2)"}>}PAGEVIEW_COUNT_last4weeks)
When I use only variable and expression I get the right result but when I use both I dont.
Again I need user list along with actual page counts in last week and last 4 weeks who fulfill both conditions
Plese help, I would be greatful.
Thanks,
Excel sheets are attahced.
