Concurrent Groups

[2004 IR Help]

By: Daniel Ruoso - ruoso

Concurrent Groups

2005-07-13 11:37

Hi,

 

I am trying to design a revenue report, and I want to group it both by month and by week, but I don't want the week to be resetted if the month changes in the middle of the week.

 

i.e:

 

Revenue Report

 

Month A

Week 1

sunday

monday

tuesday

wednesday

thursday

friday

saturday

Total for Week 1: XYZ

Week 2

sunday

monday

tuesday

Total for Month A: XYZ

Month B:

wednesday

thursday

friday

saturday

Total For Week 2: XYZ

 

 

Something like that...

 

any ideas?

 

 

 

 

By: C-Box - c-box

RE: Concurrent Groups

2005-07-13 12:48

Make a method that returns the weeknumber by a given date.... so you could group by this weeknumber and the second group is by month.... not tried but should work. The Incrementer should of course increment the sum by weeknumber and month separately... so don't think that you will have resetted values if the month is starting at the middle of a week. Not tried but interesting for me also.

 

just try it and post if (and how) it works

C-Box

 

 

 

 

By: Daniel Ruoso - ruoso

RE: Concurrent Groups

2005-07-13 13:02

Hmmm...

 

I don't think I understand it...

 

Wouldn't this make the month to be resetted on week change?

 

 

 

 

By: Daniel Ruoso - ruoso

RE: Concurrent Groups

2005-07-19 13:35

Anynone has any idea? Or this feature simply doesn't exist?