Using an Excel 2013 ProPlus PowerPivot pivot table, I have the following: (+
indicating a drill-down point)
+Attribute-1
+Attribute-2
Attribute-3
Attribute-4
Below is what I would like to have:
+Attribute-1 Attribute-2
Attribute-3
Attribute-4
Attribute-2
is functionally dependent on Attribute-1
(they are both attributes of the same table).
If I were using an Excel pivot table to view a SSAS OLAP cube, I would select OLAP Tools
=> Property Fields
and select the desired properties that I designated as not participating in an hierarchy when I designed the cube. This would allow me to display related data on the same row without a drill-down.
I cannot find the equivalent functionality in the PowerPivot model or elsewhere.