I am having 2 issues in Financial report/
1. In my report I setup the row as "prompt for entity" for users. What ever the entity choose by users,
1. Need all the level 0 of that hierarchy (Not descendants). - How to do this?
2. And, Also need the sum of all the Level 0 Members ( I will insert one more for that ) - ??????
I appreciate for your help.
You said Entity is in Row and if you want the sum of all level 0 entities (according to question 1) then you should be insert a formula row not column.
Yes it works for me.
Rows:Descendants of Prompt for Measures AND System-defined member list Lev0,Measures
Columns: Children of Year
Works fine for me. Question that I've is, when you are in studio can you see 4 rows and 3 columns ( then only you can use [C,4])
If that cell is a result of expansion then you'll have to do something like 1/[A(c),1(4)]
Column A is expanding to 3 or more and Row is expanding to 4 or more rows.