Date: | Thu, 19 Aug 2004 12:36:23 +0100 |
From: | Ed Wandasiewicz <wanded [...] breathemail.net> |
To: | bug-DBIx-SQLCrosstab [...] rt.cpan.org |
CC: | gmax [...] cpan.org |
Subject: | bug DBIx-SQLCrosstab 1.17 |
I am using DBIx-SQLCrosstab-1.17. I changed test.pl that came with the
installation and set up the following
my $col_names = [ 'name',
'location',
'color',
'low#low',
'low#high',
'high#high'];
my $records = [
[ '*Fred*', '*A1*', '*red*', '0', '0', '10'],
[ '*Fred*', '*A1*', '*black*', '1', '8'],
[ '*Fred*', '*A1*', '*blue*', '0', '2'],
[ '*Fred*', '*A2*', '*blue*', '1', '3'],
[ '*Barney*', '*A1*', '*red*', '0', '3'],
[ '*Barney*', '*A1*', '*blue', '1', '8'],
[ '*Barney*', '*A2*', '*black*', '1', '5'],
[ '*Barney*', '*A2*', '*blue*', '2', '0'],
];
I then asked for output as_html.
I would like subgrouping along the rows by "name^location^color". It would
seem you can only group by 2 different rows, maximum. e.g. name^location
or name^color or location^color.
The solution would be to set the other grouping in columns.
Should you be able to group along rows as well, or was it not designed
this way?
Ed.