why my sales table disable when i select GL Table field name = 1 REVENUE

[paulyeo11]

Hi All

I have a QV doc i have a GL_Table , it work fine. But i need to add sales table in order to have drill in feature.

So i add sales table into my QV doc.  Now both GL table and Sales Table can display their data on chart (A) and (B)

The problem happen is when i click on field name = ACC_NAME , i select 1 REVENUE

it start to disable my sales table.

My question is how to make it when i select 1 REVENUE , and all my sales table data also selected.

Paul

[paulyeo11]

Hi All

Enclosed my QV doc.

Pls note that Tab name = SALES TABLE , is the script which i add sales table data into GL Table.

May i know how to modify my script , so that when i select ACC_NAME=1 REVENUE , all my sales table data will not be block.