SDN,
I need to create a report like -
Profit center1 Profit Center2 PC3 PC4 PC5 ... till PC20
Account
001 10 20 30 40 50 ... 100
002 10 10 10 10 10 100
North 20 30 40 50 60 200
On rows, I need various account with their hierarchy, I should be able to expand account hierarchy node when wants to see details.
in Column... I need various profit center (on header) and data filled with various revenue. so intersection of account and profir center - should be revenue in that acoount from profit center.
Revenue - is based on formula - Ned to define based account-profit center interaction using Cell edit.
In order to create cell - I need two structure, so account I am making part of structure.
trouble is - I am not able to expand account hierarchy?
If I do not make account as part of strcuture, I can not use cell concept. If include them in struc... can not expand/drill on them?
profit center can be expanded as it is outside structure (of key figure)
what I am messing?