grouping and dynamic columns

[ktrinad]

By: mimisam - mimisam

grouping and dynamic columns

2003-10-17 00:30

I need to make a report with the following format:

 

Original data:

 

method A method B method C

day1 value

day1 value

day1 value

day2 value

day2 value

 

format that is needed:

 

method A method B method C Total

day1 sumA sumB sumC sumABC

day2 sumA sumB sumC sumABC

------ ------- -------- --------

totalA totalB totalC total

 

 

questions:

If day1 used method C and day2 didnt, sumC in day2 should be displayed as 0. If method C is not used in both day1 and 2, i dont want to display the column of methodC, how should i configure it so that it is dynamic? (eg. sometimes there can be 3 methods and sometimes less or more.)