Variable Rollups

building reports desktopintelligence
1

I have the following situation:

PERIOD WEEK Actual Forecasts 7 27 2000 2500
2000
7 28 3000
3000
7 29 4500
4500

What I want to see when I rollup to Period is the following:

PERIOD WEEK Actual Forecasts 7 27 2000 10000
9500

What I get is the following:

PERIOD WEEK Actual Forecasts 7 27 2000 10000
2000

any suggestions??

Dianna Anderson - TUSC
(303) 277-2330 Coors
(303) 985-2213 TUSC Office
Dianna.anderson@coors.com
Andersond@tusc.com

Listserv Archives (BOB member since 2002-06-25)

2

I may be mis-understanding the problem, but in the desired result set you list, WEEK still remains. If you wish to rollup to the PERIOD level, you will need to remove WEEK from your request.

Sorry if I have misunderstood the problem.

HTH,
Donald May
maydp@pweh.com

Listserv Archives (BOB member since 2002-06-25)