Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)