Straight table data not filtering

[sibin_jacob]

Hi,

I have two straight table. One is for physician level data another one is for ZIP level data.

In backend my data is in Physician level. I am rolling the physician level data to show the ZIp level.

When I am selecting a physician, my zip level table is not get filtered . its showing all the zips.

In ZIp level table my dimension is ZIP and expression is

sum ({$<Product_ID={1},Physician_Name=>} Volume)

I need Filtered Zip in Zip level table.

Thanks,

Sibin Jacob

[sujeetsingh]

Why dont you paste a sample..

[sibin_jacob]

Hi,

Here I attached my sample application. I need Zip level volume in Zip level table and physician level volume in physician level table.

When I am selecing a physician I need to filter zip level table  based on physician. If I am selecing one physician from ZIP1 , In Zip level table I need to show only Zip1 and the volume 50.

Thanks,

Sibin Jacob.

[sujeetsingh]

Hi ,

I dont get that why are you using set analysis..

[sujeetsingh]

See the attached file it is workin fine..

[sibin_jacob]

Hi,

In this attached file Zip filter is working fine. But I am not getting exact value in zip level. Using set analysis I am getting the exact value in Zip level.

Zip1 value is 50.

Based on physician selection my Zip value is changing. I don't want to change Zip level value. But I need to filter the zip.

Thanks,

Sibin Jacob