Small questions about Set Analyses - witch we all love so much :-)

[anitamelbye]

Dear all smart people out there,

My report is a financial report, showing 10 weeks at the time, but I only want certain number to show in certain weeks.
(The reason for calculation the week, is that I have divergent weeks/periodes..)

Is it popssible to write something like this:

SUM({$<Year={$(=Year(Today()))},[Week(Today()+(7*4)]= {11,20,28,37,46}>} Sales)

in order to only get sum if week = 11,20,28,37,46

My problem is the "[Week(Today()+(7*4)]="-part, I dont think I can write it like this.

Any suggestions?

*Still feel like a newbee, still very much in love*

[#2 · Accepted solution]

Hi,

is it possible to solve in the load script?

You could set a flag for the weeks you want to display and use that in your set analysis...

Regards

Martin

[anitamelbye]

OMG! Why did I not think of that.. Thank You!!

*like I said - still a Newbee* 😉

[#4]

What does "setting a flag for the weeks in the load script" mean??