Submitted by markfoley on 2009/06/14 22:45
a) When you do a pivotable like below with SUMS of fields, you would expect it to show only totals rather than line level detail of each amount.  If I had pulled the descs in it would be different as it would 'group by' those also.  You can click the little minus sign for each one but that would take a long time on larger pivotables.
 
 
b) Also if you close IQ with a pivot open the pivot does not auto-reopen like a grid would, is this intentional?  It does retain settings though which is great news.
 
cheers

Comments

a) The OWC components have separate documentation, which you can access by pressing the ? on the pivot table toolbar.
 
quote from OWC doc:
[quote]

Show or hide detail data for an item or field

  1. Do one of the following:

    • To show or hide detail data for a cell, or an item at the lowest level, select the item or cell.

    • To show or hide detail data for a row or column field, select the row or column field.
  2. Click Show Details or Hide Details on the PivotTable list toolbar.

Note   To show or hide lower-level items, select the row or column field or item, and then click Expand or Collapse on the toolbar.

[/quote]

The Show detail and hide details buttons are between the expand / collapse and the refresh (!) buttons

b) Yes, by design. Currently, pivot tables/charts must be opened from a grid, you can't open a pivot table/chart directly

 

markfoley

2009/06/15 01:31

Permalink

Thanks for that.  I was picturing the chart/pivot as almost a 'child' of the grid that would become visible when you open the grid (if it was open last time).  Then if you had an exercise tracker (say) you would move to that grid and see it with its chart.  Clicking on another grid with no open pivot would make that other panel disappear.
 
Anyway its still fine I think- remembering the settings is the main thing!  :)