J
Jumbo Shrimps, Jr.
Have 12 months of data,
most with nine groups.
Need to divide the sum of
all groups $ by
the sum of all Units
and array each month
as the column header.
Row header (not shown)
is the Office.
Data looks like this:
Dollar Unit $/Unit
Month GRP Value Value Value
Month1 Grp1 61295 115 533
Month1 Grp2 53295 95 561
Month1 Grp3 26055 45 579
Month1 Grp4 22163 37 599
Month1 Grp5 64785 105 617
Month1 Grp6 62426 98 637
Month1 Grp7 51903 79 657
Month1 Grp8 56700 84 675
Month1 Grp9 48774 66 739
Here is the current cross-tab expression
for value:
Expr1: SUM(([Dollar]/[Unit])) = 5597
However, the accurate result is:
Tot
Tot $ Units
SUM 447396 / 724 = 622
Expected Output:
Office Month1 Month2 Month3 Month4
New York 622 715 650 622 611 649
Oakland 642 745 350 421 522 929
etc.
There are always twelve months of data,
but not always nine groups to rolll up.
most with nine groups.
Need to divide the sum of
all groups $ by
the sum of all Units
and array each month
as the column header.
Row header (not shown)
is the Office.
Data looks like this:
Dollar Unit $/Unit
Month GRP Value Value Value
Month1 Grp1 61295 115 533
Month1 Grp2 53295 95 561
Month1 Grp3 26055 45 579
Month1 Grp4 22163 37 599
Month1 Grp5 64785 105 617
Month1 Grp6 62426 98 637
Month1 Grp7 51903 79 657
Month1 Grp8 56700 84 675
Month1 Grp9 48774 66 739
Here is the current cross-tab expression
for value:
Expr1: SUM(([Dollar]/[Unit])) = 5597
However, the accurate result is:
Tot
Tot $ Units
SUM 447396 / 724 = 622
Expected Output:
Office Month1 Month2 Month3 Month4
New York 622 715 650 622 611 649
Oakland 642 745 350 421 522 929
etc.
There are always twelve months of data,
but not always nine groups to rolll up.