Query issue

[former_member541575]

Hi

I have requirement where i have to show Category A, under that Category A, Revenue field and Bonus field will be shown in multiple rows.

for Category B Revenue field and Bonus field will be shown in multiple rows.

the question is how to show the this Category A and Category B

Is it possible by creating a new Structure.

Regards

Atul

[former_member324842]

Hi Atul

Yes we can achieve this with the help of structures(by means of hierarchical relationship) . First create two structures stru1(for categ-A) and stru2(for categ-B), under these structures add revenue and bonus fields respectively and arrange them in order by right clicking on the structure(level up and level down). When you execute the query initially you can see Cat A & B and further you expand it will shows you complete report.

Hope you understood