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; } } }

How to add heading in cross tab for summary fileds

venkatmadh

hi i am facing small problem, i am using 3.7.2 birt version my problem description

please look at following image , ( this cross tab report of summary fields portion) in cross tab image , all subjects are summarily fields like Maths,social,.....etc Now I want to give super heading for all summaries fields like Subjects exmaple

| Subjects | school Name

|Maths | science | English |-

ABC | 20 | 30 | 40 | please give me one example on that Advanced Thanks

Find more posts tagged with

Comments

mwilliams

You could add a label in a grid above your crosstab and put your category name in it. You could create a computed column with the value of "Subjects", then use this as a dimension in your cube and the subject field as the sub-group. Hope this helps.

venkatmadh

H wiliams , Thanks for quick reply........... if it possible give me one example on that............ Advanced Thanks

mwilliams

Here's an example. It uses a scripted dataset, so the computed column isn't exactly how you'd probably do it, but all you would need to do is to go into your dataset editor, go to the computed columns section, create a new computed column of string type, and use the expression "Subjects". This will create a column with all rows with that value. From there, you just use the field as a dimension in your cube and crosstab. Hope this helps.

venkatmadh

hi williams thankyou for quick reply, attached design almost suitalbe for my requirement, but ,In case multiple headings , it is not working ... plese look following design please provide an idea on that or if it is possibleplease provide some sample on that

| Subjects | Pecentages | grade | school Name

ABC | 20 | 30 | 40 | 20% | 30% | 40% | a | b | c | Advanced Thanks

mwilliams

You would have to determine a way to change the value of the "header" field to the appropriate value in your computed column. Can you post a sample of what your actual data looks like?