Dimension/Expression question in pivot table chart
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?
