Cross Tab - Group by Fields

[saran26]

Hi All,

I have row wise Group added to the cross tab.

I have to show other details along with the group name , How can I do that in the Cross Tab. When ever I tried to add that field it always consider that as a group and puts it in the next line.

Example

ID is my group by field and count is summary field


ID Summary

1 10
2 20

I need to add the other column priority also in the same line along with the id

ID Priority Summary

1 p1 10
2 p2 20

But I dont want to group based on the priority, how to achieve that ?

Please help me out,

Thanks
Saran

 

[lbass]

If the second value is unique to the first, it shouldn't create a second line. You can suppress the additional subtotal on the customize style tab. Alternatively, you could concatenate the two fields, and use that as your row field.

-LB