Data set analysis

[#1]

Hi all,


i've got this statement:

Sum (
 {1<
 Calendar.Week={$(=Max(Calendar.Week))}
 >}
 NetSales
)

But now i want to also include the CalDate:

The result has to be the sum of NetSales for the max week but smaller or equal than the day selected

So I thought is was something like this:

Sum (
 {1<
 Calendar.Week={$(=Max(Calendar.Week))},

 Calendar.CalDate={$(<=(Calendar.CalDate))}
 >}
 NetSales
)

But this aint working correct.
Can anybody help me?

Tnx in advance

Reyman

[#2 · Accepted solution]

Give this a try:

Sum({1<Calendar.Week={$(=Max(Calendar.Week))},Calendar.CalDate={'<=$(=Calendar.CalDate)'}>} NetSales)

I pulled the less than or equal out of the dollar-sign expansion and put the whole Set Modifier in quotes.

The easiest way to test Set Analysis is to put your expression into a chart, but don't give it a label. On the chart, the label for that expression will be the Set Analysis expression with the dollar-sign expansion evaluated.