computer freeze when making calculated total field in pivottable .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003, Qurey, PivotTableView:
I made query with pivot table view from single table (it has only 270
entries). I noticed that computer freeze whenever i create another
calculation field when there is more than four row fields.
I test same thing in another query with same sql with less than four row
fields, it work OK.
In both cases, I filtered none.
How can I create more calculated total fileds with more than 4 row field.
Please make a suggestion...

Brgds,
Zaw
 
There may be no one interested in my topic (pivottable view).
I found no limitation on pivot table making in help files (as far as I
searched), but I solved with non-professional method.
i.e pivot table view usually freeze when (row field + total filed) > 15 OR
16 columns. that why i think. I reduced some fields (row or total) and add
another calculated total field. Its works OK!. So, we have to maintain the
total columns to be less than 16 to run efficiently. Shouldn't Microsoft be
eliminate this limitation...

If some body found another approach, let me know.
brgds,
ko zaw
 
Back
Top