Dividing sum into two invented dimensions

[damianm]

Hi,

I would like to divide my sum into two invented dimensions in my pivot table. Just now i have sum of Sales for Germany equal to 1000.

I want to create "fake" dimmension Region and create two levels West and East.

It means that i would like to divide this sales like West=70%*Sales and East=30*Sales.

I cannot interfere into data model.  Is it possible to do it with set analysis?

[tresesco]

You can use second dimension as:

ValueList('West', 'East')

and expression as

If(ValueList('West', 'East')='West', Sum(Sales)*0.7,Sum(Sales)*0.3)