Only show part of the result

[wanyunyang]

Hi guys,

I've got 2 tables. Table1 is a pivot table, it shows customer A and visit_date 01/01/2018, table2 is a simple table, and has all the year-to-date visit_details for customer A. If I click customer A in table1, table2 will give me all the year-to-date visit_details. Is it possible it only gives me visit_details on 01/01/2018?

Thanks for help!

[zebhashmi]

if a link in between the tables would be Date it should show only 01/01/2018

or you can use set analysis

regards

[wanyunyang]

The link is customer. How to use set analysis in this case?

Thanks!

[zebhashmi]

Only({<customer A = P(Date)>}Date)

[wanyunyang]

Could you please explain a little bit what is {<customer A = P(Date)>}?

I'm trying to write something like {<date_in_table1=date_in_table2>}.

[zebhashmi]

is it worked for you?

you are asking about p()

you can use (if )you have two different names of your fields

max(aggr(if(date_in_table1=date_in_table2,date_in_table2,'')))

or

p(date_in_table2={'date_in_table1'} in first one

[zebhashmi]

{<date_in_table1={'date_in_table2'}>}

should work

[wanyunyang]

I have the same name of my fields. Do you mean customer A is the column I should use?

Now my function is like Only({<[Customer]= P(Date)>}Date). It doesn't work.

[zebhashmi]

try that

Only({<date_in_table1={"=date_in_table2"}>}date_in_table2)

[wanyunyang]

they both named 'Date' in table1 and table2