Include Hidden Items with Totals

[BM]

Hello all,
Im using Microsoft Excel XP and after creatign a Pivot table if you view the
pivot table toolbar you can find that there is a button called "Inclue
Hidden Items with Totals" . Would anyone explain what this button is used
for and how one would activate it. Ive tried different data sources and and
different layouts but I cannot get this feature to work or I must have
understood its use incorrectly. Would appreciate any help.

Also I noted some posts about using this feature with OLAP data sources.
Would anyone be able to explain what OLAP daat sources are. Thanks in
advance.

-Biju

 

[Dave Hawley]

Hi Biju

Do you mean "Suntotal hidden page items" found under Options? If so,
this is Excel's take on it:

Includes hidden page field items in PivotTable report subtotals. In a
PivotChart report, the subtotals are affected in the associated
PivotTable report. This option is not available in reports based on
source data from OLAP databases.



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Debra Dalgleish]

The 'Include Hidden Items with Totals' feature is only available when
using an OLAP data source. You can read about these in Excel's help
files, there's information in the MSKB, such as:

XL: Differences Between OLAP and Non-OLAP PivotTables
http://support.microsoft.com/default.aspx?id=234700

and in MSDN Library:

OLAP Related Features in Microsoft Excel 2002 and the Microsoft Office
XP Web Components
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlowcolap.asp

 

[BM]

Thank you very much for your timely and excellent help. Thanks to both of
you. These forusm rocks!!!!

-BM