How to visualize more attributes of a dimension in Pivot table in Excel 2016

Question

I have a SSAS cube where one dimension is "User".

User has many attributes, say "Email", "Mobile Number", "Address" and (many) more.

I build a Pivot table in Excel 2016 where I can easily find which Users, for instance, placed orders in the current month.

Now, I want to visualize for each of these users several of the possible attributes: I just need to easily get the list of email and mobile numbers of the users that placed orders in the current month.

If I drag the required attributes in the Pivot table though, these are used to further split each row: under each User in the Pivot there will be a level with just one Mobile Phone and this will be further divided in one email and so on.

What I need is, instead, keeping the division of the Fact "Order" only by the dimension User, and for each User to just visualize some more fields. What's the best way to achieve this?

The only way we can think of so far is to have an additional attribute with the concatenation (comma separated?) of all the needed information. But this is honestly horrible. The aim should be to have each of the additional attributes in its own excel cell.

Answer 1

I think you are looking for something like this ...

1. Pivot-Table options -> Display -> Classic PivotTable layout
2. For each field on your pivot table, Field Settings->Subtotals->None

From this raw data ...

And the options above, I generate this Pivot Table ...