Jump to content
We've recently updated our Privacy Statement, available here ×

Two column groups next to each other in crosstab


bsulima

Recommended Posts

Hello,

Is it possible to have two column groups next to one another in crosstab? Is it also possible to have "normal" cells afterwards? I would like to have an report in which there are some columns with regular data ("name", "surname"), followed by two column groups ending with Total ("level <num> - A" and "level <num> - B") column followed by more "normal columns" ("OtherData" and "SomeData"). Please see attached picture to clarify what I mean. Is it even possible to add column group next to one another? Every time I try to do it in TIBCO Jaspersoft Studio it adds below the first column group

expected_result_01.png

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

I was able to create a layout that is very close.
The instructions on how to create it are very complicated, so I will just show you the key points.

* In the Crosstabulation Wizard, select all the items you want to display.
  In your example, 'Other Date' and 'SameData' are selected as 'Row Items'.
* The automatically created 'Other Date' and 'SameData' text fields will be deleted. The column width is also set to '0px'.
* Delete the text fields in the automatically created grand total.
* Create a new text field to display 'Other Date' and 'SameData' in the grand total.
* I will omit the detailed explanation, but please note that the 'Layouts' of each item must be changed to 'Free Layout' in order to be placed properly.

The concept is summarized as follows.
* Create a cross tabulation table using the wizard as usual.
* Delete the row items that are created by default and rearrange them in the total tally area.

 

* Design Image
w20220917_crosstab_design_1.png.5d8864576ae05c66a75631bbd5d80136.png

w20220917_crosstab_design_2.png.b8b6d88da3f2a00467b684cd72f74c36.png


* Preview Image
w20220917_crosstab_preview.png.56a3771aa69ca59cc71b9b3c4f43a508.png

 

I hope this will be helpful to you.

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...