1

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.

1 Answer 1

2

This can be done by going to PivotTable options in Excel, Display Tab and tick on "Classic PivotTable layout..." (the fifth checkbox in the image below):

PivotTable display options

Then change subtotals to not display in Field Settings:

Field Settings

2
  • Then change subtotals to not display in field settings...
    – Des
    Nov 11, 2016 at 3:21
  • Note: make sure you change field settings on Attribute-1, not a different attribute
    – Scott
    Jul 31, 2023 at 22:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .