Hi,
I looking for help to produce a report using a hierarchy and didn't found any thread or documentation about what I'm trying to do...
In row I have 3 caracteristics: Car1, Car2, Car3.
In colums: my key figures.
I want to display Car1 with a hierarchy.
Here is an example of the result I wish:
<b>__________________________________________________Amount
Car1_______________Car2_______________Car3</b>
Node 1
_Node 2
___Car1Val_________Car2 Val____________Car3Val_______1000$
But here is the result I have:
<b>__________________________________________________Amount
Car1_______________Car2_______________Car3</b>
Node 1_____________Car2 Val____________Car3Val
Node 2___________Car2 Val____________Car3Val
___Car1Val_________Car2 Val____________Car3Val_____1000$
I would like to know how to design my query so my caracreristics 2 and 3 show values only Car1 hierarchy is fully expanded.
Here is an example with my real data:
ZCS_ITEM = our corporate chart of accounts presented under a coporate group of accounts (hierarchy)
0CS_ITEM = our internal chart of accounts.
Exepcted result
<b>__________________________________________________Amount
ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>
ASSET
CURRRENTASSET
___100001__________11100___________6000____________1000$
Actual result:
<b>__________________________________________________Amount
ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>
ASSET________________11100___________6000
CURRRENTASSET____11100___________6000
___100001_____________11100___________6000___________1000$
Any ideas?
Thanks in advance!