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.