Table box calculation condition

[#1]

I am using a Table box to select data based on the two fields : Year and Company.

I am using the following condition in the calculation condition.

But when i select 2013 year and COKY company,all company data is getting populated in the table box.

Am i missing anything in the condition above.

Please help!!

[swuehl]

First of all, you are using a different expression for your calculation condition then stated.

If you use

GetSelectedCount(YEAR)=1 and GetSelectedCount(COMP)=1

You only get a table when you select a single YEAR and a single COMP.

You will still see HMA in the column DT_COM, because your table you made selections in and your dashboard table are only connected by date, so your selection in field COMP does not necessarily be reflected in field DT_COM (that's what I meant wiht different fields used in different tables, remember my first answer?)

[#3]

how to avoid other company data while i select a company here?

[swuehl · Accepted solution]

Create a list box for D_COMP (the field you are actually showing in the table box, right?).

Select in this list box.

[Anonymous]

how could this be possible when you select Year 2013 and company cocky then you youself

is filtering entire data model and there should not be any data other the for 2013 and for comapny cocky

just check your data model and please paste a screen shot of your data model and table box.

i do not feel there is need of any function as you used this is not needed when

anant

[#6]

Sooper !!

it worked!:)

[Anonymous]

Hi,

Your data model is wrong.

You have a check your data model and organize it.