nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Crosstab posible??

aaraya

Hi, 
 
I have the following data set. 
 
<img src='http://img96.imageshack.us/img96/4457/crostab2.jpg' alt='Posted Image' class='bbc_img' /> 
 
I have to show the following manner as in the picture below 
 
<img src='http://img571.imageshack.us/img571/2684/crosstab1.jpg' alt='Posted Image' class='bbc_img' /> 
 
 
Use the 4 fields as dimencion, but not found

Trans for you help 
 
best regards

Find more posts tagged with

Comments

kclark

Can you post some sample data in xml?

aaraya

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="112209" data-time="1354901017" data-date="07 December 2012 - 10:23 AM">
Can you post some sample data in xml? </blockquote>
 
kclark, see data in csv 
 
camion,ton,grupo,fecha 
CA-50,392,1,2012-09-12 10:18:34.000 
CA-52,382,1,2012-09-27 15:46:35.000 
CA-70,399,1,2012-09-19 18:26:43.000 
CA-71,396,1,2012-09-18 08:19:49.000 
CA-85,394,1,2012-09-19 12:22:24.000 
CA-50,392,2,2012-09-12 10:18:34.000 
CA-52,363,2,2012-09-28 13:45:25.000 
CA-53,383,2,2012-09-29 23:46:51.000 
CA-70,377,2,2012-09-17 21:48:49.000 
CA-85,384,2,2012-09-10 12:15:10.000 
CA-50,392,3,2012-09-12 10:18:34.000 
CA-52,363,3,2012-09-28 13:45:25.000 
CA-53,376,3,2012-09-29 12:03:02.000 
CA-71,383,3,2012-09-21 12:08:47.000 
CA-85,384,3,2012-09-10 12:15:10.000 
CA-50,396,4,2012-09-12 07:13:32.000 
CA-52,376,4,2012-09-23 20:52:00.000 
CA-53,382,4,2012-09-25 01:11:42.000 
CA-70,393,4,2012-09-07 05:18:54.000 
CA-85,380,4,2012-09-26 07:01:27.000 
 
tranks

Hans_vd

<blockquote class='ipsBlockquote' >Use the 4 fields as dimencion, but not found

</blockquote>
Why would you need it to be 4 dimensions? I see only 2: camion and grupo. The other fields can be summary fields using the FIRST function in the "Edit Summary Field" dialog.

aaraya

<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="112218" data-time="1354913857" data-date="07 December 2012 - 01:57 PM">
Why would you need it to be 4 dimensions? I see only 2: camion and grupo. The other fields can be summary fields using the FIRST function in the "Edit Summary Field" dialog. </blockquote>
 
 
I tried, but did not achieve the expected result 
 
<img src='http://img15.imageshack.us/img15/3156/crosstab3.jpg' alt='Posted Image' class='bbc_img' /> 
 
just need 5 entries per row 
 
Tranks again..

Tubal

It looks like you just need 1 table per group. Not a cross tab. Unless I'm missing something...

If you don't want to show the trucks that aren't in a group, a crosstab doesn't make sense.

I'd just do a grid with a column for each group, and then put a table in each column, filtered by the group.

Hans_vd

<blockquote class='ipsBlockquote' >It looks like you just need 1 table per group. Not a cross tab.</blockquote>
If the number of grupos is fixed, Tubal is right.