| MATRIX REPORT, VERY URGENT .......... [message #87997] |
Wed, 19 December 2001 07:07  |
Feroz Khan
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
Hi,
I have a matrix report to build , which will be a matrix report with Group . The problem is there are some Custom Calculations and Summary fields I need to put at each group level. How do I do that ? Can any one help me in this ?
If you look at the report(simulation) below, Its a matrix report with group. The first group which is the "COUNTRY" , to be displayed at the top . The other three groups are displayed as rows. One is "DEPARTMENT(Dept)" , second is "CATEGORY" and the third is "BRAND". Now the column values are the "MONTHS". The report is basically to print in a perticular Year(S), what is the sale for the items(Brand) , for each 'Category', for Each 'Department' in each 'Country' . So lets say in a Dept 'HHN', Category 'Laundry' there are 10 Brands(Surf ,... etc). So In the left side it shows one Dept value (HHN), one Category value (LAUNDRY) , and brands(SURF,...etc) one after another downwards. So for each brand what is the $ Sales , Unit Sales and some calculations. Once the Brands are done, then in the next rows it should print the values for the Categories , i.e. Category Total of $ Sales, Unit Sales and same set of calculations will be done( in case of calculations it wont be summary as in case of $ Sales and Unit Sales). Once all the cateogry are done then it should Print the totals and the calculated values at Department Levels. Finally for the country level. Hope this explains the requirement. Please help.
Thanks
Feroz
............................COUNTRY ----> This is the top group
<---- GROUPS------>................<----COLUMNS MOVING ACCROSS ------>
DEPT..CATEGORY..BRAND..............Month1 Month2 Month3 Month 4 .....
________________________________________________________________
HHN...LAUNDRY...SURF.........Sales 800000 |
.....................................................Units 20000 |
..............................................Avg Price 40 |=> These are the row
....................................................Calc2 300 |-These are calculaations
....................................................Calc3 270 |-/
________________________________________________________________
.
.
.
.
________________________________________________________________
LAUNDRY TOTAL...................Sales
...................................................Units
............................................Avg Price
..................................................Calc2
..................................................Calc3
_________________________________________________________________
HHN TOTAL.............................Sales
...................................................Units
............................................Avg Price
..................................................Calc2
..................................................Calc3
_________________________________________________________________
.
.
.
.
_________________________________________________________________
GRAND TOTAL........................Sales
...................................................Units
............................................Avg Price
..................................................Calc2
..................................................Calc3
_________________________________________________________________
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
