See almost all Microsof company Shine suggestions
Strategy:
You are able to turn away from subtotals for almost any industry.
1) Double-click the particular Time industry. Modify the particular Subtotals establishing coming from Programmed to be able to Probably none Ibm Thinkpad T43 Battery, since demonstrated inside Fig. 960.
2) Double-click the spot industry. Modify the particular Subtotals coming from Programmed to be able to Probably none Dell latitude d830 Battery, since demonstrated inside Fig. 961.
Result:
As zxcsky32645 demonstrated inside Fig. 962 hp pavilion zv5000 battery, each line inside the pivot stand is currently any info level. In the event you replicate and also stick this kind of stand with a fresh workbook dell vostro 2510 battery, you'll not must personally erase every one of the overall series.
Summary:
When you might have multiple Line industry, it is possible to eliminate the programmed subtotals around the outside career fields so that you can make a clean seeking record.
Commands Reviewed:
Data �C PivotTables �C Subtotals
See almost all Microsof company Shine tips
Image
没有评论:
发表评论