show data in straight table with a specific date

[yelin_nyu]

Hi,

Please see the attached test file. I want to show a trend of data in the line graph, but only weekly data (if no specific week is selected, then display the most recent week, otherwise, display the selected week), and new data comes in every week.

The problem here is, without any selection,  order_qty table shows count of order flag based on week 1-4. But I don't want it to accumulate the count. In the table it should say

total                      10          2

123      banana     9            1

456      apple        1           1

And I don't want to bring in week field, because that will create a lot of rows. i don't want to display historical data unless there is a reason to. (but some ppl might want to see week 1 or 2 or 3)

the graph should be a trend (i can't detach the graph, because if i just want to see apple or banana, it wont allow me to do so)

Thanks

[perumal_41 · Accepted solution]

Hi

I have uploaded Application.this one useful for u.

[yelin_nyu]

Hi Perumal A,

if i were having aggr() function, does it work? This code worked on sum() count() functions, but it didn;t seem to work on aggr functions.

the code looks like this: sum({$<Week={'$(=Max(Week))'}>} aggr(sum(ordered), product, Week_day))

i was trying to find the total units for a particular product on a specific day (i know if my sample test file i didn't make a week_day field, but you get the idea). I think the expression total was right in this case, except there is no data shown from line wise. please advise.

Big thanks