NEED ADVICE about Inserting a custom formula column in EXPANSION memberset

61 Views

Dear all:

I am asked to create a report with TIME(col), ACCOUNT(col), PRODUCT(row), where ACCOUNT stores Beginning Inventory Amt, COS, etc.

The problem I am having is that the user requests to have a place to show COS ratio column. COS ratio value is derived from ACCOUNT COS and ACCOUNT NETSALES of my ACCOUNT MEMBERSET.

I tried various ways but was unable to keep the formula in EVDRE so this COS ratio column's formula goes with the rest of the expansion.

The result I want is something like below, where NETSALES and COS are my dimension members and RATIO is Excel formula STDCOST/COS... As the report expands by different TIME hierachy (i.e. 2008.total, 2008.h2, 2008.q3), RATIO is expanded accordingly.

Is this doable in EVDRE?

2008.10 2008.11 2008.12

NETSALES COS RATIO NETSALES COS RATIO NETSALES COS RATIO

PRODUCT1

PRODUCT2

PRODUCT3