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

rockjava123

| Subjects | Pecentages | grade | school Name

ABC | 20 | 30 | 40 | 20% | 30% | 40% | a | b | c | please help me Advanced Thanks</div></div>

Find more posts tagged with

Comments

mwilliams

The headings you have would just be another dimension in your cube. So, you'd need to have a field in your dataset that had a value for the heading group. The crosstab would do the rest.

rockjava123

Hi wiliams Thanks for Quick reply.................. colud please provide one example on that or give me some useful links Advanced Thanks

mwilliams

Can you show me exactly what your data looks like? I think I talked with you on the NewsGroup about this and there was some confusion to how you'll know what type of data you'll have to create the header or if there is something in your data that tells you. Let me know. Thanks!

rockjava123

hi william thanks for quick reply, all are header of crosstab , we will decide based on summary columns, if it is possible give one exmaple.. Advanced Thanks

mwilliams

Sure. An easy example to explain would be to say you had data like: YEAR (row dimension) | Product Line (Header) | Product (Column dimension) | Sales (Measure) If you created a cube with YEAR as one dimension, Product Line (your header field) as another dimension, Product as a sub dimension of product line, and sales as your measure, these "headers" would automatically show up. I can build this example if you'd like, but you will have to have a field to be the header value. You can create a computed column in your dataset to determine this field's value for each row based on the other values in the row, but somehow, you'll need to have this "header" field. Hope this helps.

rockjava123

hi williams, Thanks for quick reply , could you please provide an example on that. Advanced Thankyou

mwilliams

Sure. What is your BIRT version?

rockjava123

Thanks for quick replay, my Birt Version 3.7

mwilliams

Here is an example. If you look at the preview of the results in the dataset, you'll see how the results are returned. The crosstab then easily shows the header for the different groups.