K
kiln
I have about 170k data points in a well indexed single table. The OWC 10
Pivot table is set up to filter by two fields, and has a single col a
single row. I've left the form just as the wizard creates, no changes.
If I filter by one selection each for the two filter fileds, the next
time I open the form it must take 20 seconds to open. And that is the
best case scenario, more complex filtering slows it even more. Changing
a filter element requires about five seconds to rebuilt the pivot table,
as long as I keep the filter simple.
With speeds like this, the pivot table is unusable. I could prefilter
the dataset, but then I lose the pivot table aspect don't I?
Are there any websites that offer help and insight with using the pivot
table?
Pivot table is set up to filter by two fields, and has a single col a
single row. I've left the form just as the wizard creates, no changes.
If I filter by one selection each for the two filter fileds, the next
time I open the form it must take 20 seconds to open. And that is the
best case scenario, more complex filtering slows it even more. Changing
a filter element requires about five seconds to rebuilt the pivot table,
as long as I keep the filter simple.
With speeds like this, the pivot table is unusable. I could prefilter
the dataset, but then I lose the pivot table aspect don't I?
Are there any websites that offer help and insight with using the pivot
table?