Questions about Power Pivot Layout

%3CLINGO-SUB%20id%3D%22lingo-sub-2337904%22%20slang%3D%22en-US%22%3EQuestions%20about%20Power%20Pivot%20Layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337904%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20some%20questions%20about%20the%20layout(format)%20of%20a%20pivot%20table.%3C%2FP%3E%3CP%3Ei%20hope%20that%20someone%20can%20help%20me%20with%20this%20issues%20and%2For%20can%20tell%20me%20where%20i%20can%20find%20a%20good%20tutorial%20about%20the%20layout%20of%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Sometimes%20you%20get%20as%20title(subtitle)%20of%20a%20pivot%20table%20%22Sum%20Of%20(field%20which%20is%20used%20in%20values).%20When%20you%20post%20more%20values%20or%20maybe%20also%20in%20other%20cases%20you%20don't%20get%20this%20title%2C%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20add%20this%20title%20manually%20in%20one%20or%20other%20way.%20Maybe%20in%20an%20option%20menu.%3C%2FP%3E%3CP%3E-Sometimes%20it%20is%20not%20possible%20to%20add%20a%20filter%20to%20a%20column%20of%20a%20pivot%20table.%20Can%20someone%20tell%20me%20what%20the%20reason%20can%20be%20of%20this%20feature%3C%2FP%3E%3CP%3E-In%20one%20Pivot%20Table%20I%20can%20add%20the%20filter%20to%20line%20of%20the%20column%20names%2C%20but%20i%20can%20add%20them%20the%20blank%20row%20above%20the%20row%20with%20column%20names.%20Can%20anyone%20explain%20the%20reason%20of%20this%20feature%20and%20how%20i%20can%20resolve%20this.%3C%2FP%3E%3CP%3E-In%20several%20pivot%20tables%2C%20i%20get%20Row%20Names%20or%20Row%20Label%20as%20name%20of%20my%20first%20column%20Header%2C%20the%20other%20fieldnames%20of%20the%20columns%20are%20the%20names%20of%20the%20attributes%20that%20i%20selected%20in%20my%20Pivot%20Table%20as%20row.%20Can%20anyone%20explain%20the%20reason%20of%20this%20feature%20and%20how%20i%20can%20resolve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%20In%20Advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Best%20Regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2337904%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337939%22%20slang%3D%22en-US%22%3ERe%3A%20Questions%20about%20Power%20Pivot%20Layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1014133%22%20target%3D%22_blank%22%3E%40MarcBergmans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20provide%20a%20workbook%20with%20examples%20so%20we%20can%20investigate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337952%22%20slang%3D%22en-US%22%3ERe%3A%20Questions%20about%20Power%20Pivot%20Layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1014133%22%20target%3D%22_blank%22%3E%40MarcBergmans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20it's%20better%20to%20explain%20on%20example.%20In%20general%20it%20depends%20do%20you%20use%20compact%20or%20tabular%20view.%20In%20tabular%20view%20you%20have%20field%20names%20as%20they%20are.%20In%20compact%20form%20you%20may%20aggregate%20on%20more%20than%20one%20field%20(e.g.%20Country%20%26amp%3B%20City)%2C%20thus%20you%20have%20Row%20label%20by%20default.%20You%20may%20double%20click%20on%20it%20and%20change%20the%20title.%20Which%20aggregation%20do%20you%20use%20in%20Values%20affects%20column%20name.%20By%20default%20that's%20Sum%20for%20numbers%20and%20Count%20for%20texts.%20You%20may%20change%20aggregation%20in%20Value%20Field%20Settings%20as%20well%20as%20column%20change%20and%20its%20format.%20Filter%20-%20depends%20on%20do%20you%20use%20label%20filter%20or%20value%20filter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I have some questions about the layout(format) of a pivot table.

i hope that someone can help me with this issues and/or can tell me where i can find a good tutorial about the layout of a pivot table.

 

-Sometimes you get as title(subtitle) of a pivot table "Sum Of (field which is used in values). When you post more values or maybe also in other cases you don't get this title,

is it possible to add this title manually in one or other way. Maybe in an option menu.

-Sometimes it is not possible to add a filter to a column of a pivot table. Can someone tell me what the reason can be of this feature

-In one Pivot Table I can add the filter to line of the column names, but i can add them the blank row above the row with column names. Can anyone explain the reason of this feature and how i can resolve this.

-In several pivot tables, i get Row Names or Row Label as name of my first column Header, the other fieldnames of the columns are the names of the attributes that i selected in my Pivot Table as row. Can anyone explain the reason of this feature and how i can resolve this.

 

Thank You In Advance

 

My Best Regards

2 Replies

@MarcBergmans 

Please provide a workbook with examples so we can investigate.

 

@MarcBergmans 

Yes, it's better to explain on example. In general it depends do you use compact or tabular view. In tabular view you have field names as they are. In compact form you may aggregate on more than one field (e.g. Country & City), thus you have Row label by default. You may double click on it and change the title. Which aggregation do you use in Values affects column name. By default that's Sum for numbers and Count for texts. You may change aggregation in Value Field Settings as well as column change and its format. Filter - depends on do you use label filter or value filter.