Filter data in straight table

[#1]

Hello,

I know it's been discussed several times, but after two full days of searching, I failed in making it work [:(]

Tables :

• Relations (= Clients)
• Personel (= Account Managers)
• Events

I created a straight table which is showing me all the clients and the calculated sales. This table does not rely on previous selections made. But I want to create a table per Account Manager.

Where (and how) can I state in the table to show me only the clients from one of the Accountmangers.

From Table 'Personel', field 'Initials', I thought Calculation Condition : =IF(Initials='AHE') would show me the clients of AHE...

I know, it's stupid, but I cann't get it to work

[#2]

Hi

I'm not sure why you want to place a filter inside the object, why don't you just provide a list box so the end-user can select which account manager they want to see?

[#3 · Accepted solution]

If, however, you do have a good reason to filter inside of the object itself then maybe a calculated dimension would work, something like:

=IF(AccountManager='ACE' , AccountManager )

[#4]

Because each Accountmanager will get its own sheet (apart from the comparison-sheets which are allready made).

The sales-director asked me to make a seperate sheet for each accountmanager.

[#5]

THX !!!

Like I thought : very simple !

Problems solved !!