How to filter another table based on current pivot context?

Hi Anonymous,

>>What does this temp use for?

Temp is the current value on row content. Actual, when these function limit at row content level, I can use them to get current value.(max or other math functions used to get current number/date value, lastnonblank suitable with get text)

Detail description of formula:

1. Rows field property1 is from tableA, I can use lastnoblank function to get current value of row content;

2. Columns field is from tableB, I can use max function to get the current value of row content.

3. Based on above variables, I can filter the same records from all of tableB with the same property1 form tableA and the current property2 form tableB, then get the row count as the result.

Maybe above description is complex for understanding.:smileyhappy:

Regards,

Xiaoxin Sheng