Adding Multiple Row in Cross Tab Report

meenakshi
edited February 11, 2022 in Analytics #1
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:


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.


Comments

  • jfranken
    edited June 22, 2020 #2
    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:
    ID
       Asset Type
          Asset ID

    I hope the helps.
    Warning No formatter is installed for the format ipb
  • 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.