Toad World® Forums

Pivot table filtering problem


#1

I ran a query in Editor that returned > 800k records. I encountered a problem
with the filter on the Pivot & Chart tab (see screenshot below). When I
select the filter icon on the field (e.g. ‘CHANNEL’, shown below)
instead of a list of values TDA displays the Pivot Grid Field List.

This transmission may contain information that is privileged, confidential,
legally privileged, and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any disclosure,
copying, distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect that might
affect any computer system into which it is received and opened, it is the
responsibility of the recipient to ensure that it is virus free and no
responsibility is accepted by JPMorgan Chase Co., its subsidiaries and
affiliates, as applicable, for any loss or damage arising in any way from its
use. If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.

image001.png