I have a requirement like
I have a column with Departmentwise Actual amount grouped by Region.
Under Asia Group A,
Department Actual Amount
A,B,C,D,E are coming from database. But not sure for every group all the departments(A,B,C,D,E) are present.
So, When I insert calculated member under 'E' as 'F' and 'E' value is not available in database for Department then F is also not showing. F is disabled.
So, how can I show 'F' value everytime even when either of A,B,C,D,E are not in database?