Adding Multiple Row in Cross Tab Report

Hey All,

I want to design a report which has multiple row area in the cross tab report. I added it but now unable to add a column.
The design of that report should look like this:

Image: https://us.v-cdn.net/6030023/uploads/editor/xy/3fphrq6gc2am.png

Can anybody suggest to me if I can use a cross tab approach or if something else will work?

Any help will be appreciated. Thanks.

Find more posts tagged with

Magellan BI & Reporting

Comments

jfranken

The attached example creates a row for each Country, but it also has a subgroup for each State. Look at the cube groups and you will see the State subgroup that was created. In your design, it looks like you have three levels of grouping:

Asset Type

Asset ID

I hope the helps.

meenakshi

Thank you Jeff for the report.
This report helps me to understand the hierarchical structure of the cross tab or data cube which I didn't know before.
Now I can group the table as per the number of columns I will add in the report later.

Thanks again.