M
mangaraju venuturupalli
Hello,
I have an account dimension, with members like REVENUE, COST, WIP and
so on. And I have a calculated member called "TOTAL COST" created from
this dimension which is (COST + WIP).
Now, here is what I have in pivot:
- ROW dimension (time)
- COLUMN dimension (currency, account) ... there's only one member in
currency.
When I show the pivot, I have a case, where REVENUE is zero and COST
is non-zero. In this case, if I choose to display REVENUE (a zero
regular member) and "TOTAL COST" (a non-zero calculated member), the
pivot is going blank.
Is this a known problem ? Could anyone please help ?
Thanks a lot.
I have an account dimension, with members like REVENUE, COST, WIP and
so on. And I have a calculated member called "TOTAL COST" created from
this dimension which is (COST + WIP).
Now, here is what I have in pivot:
- ROW dimension (time)
- COLUMN dimension (currency, account) ... there's only one member in
currency.
When I show the pivot, I have a case, where REVENUE is zero and COST
is non-zero. In this case, if I choose to display REVENUE (a zero
regular member) and "TOTAL COST" (a non-zero calculated member), the
pivot is going blank.
Is this a known problem ? Could anyone please help ?
Thanks a lot.