Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a scenario like this:
I want to display sales pivoted by customer(X) and year(Y) - two dimensions I have. The figure I use as formula is =SUM(SalesAmount).
In addition - I would like to display several more fields from the customer - such as Customer Code, Customer Currency, Customer Phone and so on.
Those fields are not exactly dimensions, since there is only one for each customer - so I want them to be shown always when customer dimension is expanded - so I cant just add them as dimension
Those fields are not exacly expressions - If I add them as an expression, they will be replicated several times which is also no good.
If I make a calculated dimension composed of several fields, or create a new concatenated field on the structure level - it doesn't look good and cant be exported to excel properly.
Is there any proper solution to this rather typical scenario?
Thanks
Never mind, got it
Never mind, got it
And the answer is.....???