Yes, Its been 4 days im trying to solve this and still didnt get it right. I illustrated the problem on attached picture.

Basically in I9 cell i want to copy the value $25 on the left table, so i need to make function that find "adam" , pay "books", in period "1". And then on J9 cell it should be find "adam" , pay "books", in period "2". How to solve this in filemaker? i find out its very easy on excel. Please help

 

Thank You

It sounds like you're looking for what's called a cross-tab or pivot report. You'll find a lot of hits if you google that, for example:

https://www.teamdf.com/blogs/a-lightweight-cross-tabular-data-entry-method/

https://filemakerhacks.com/2016/04/27/virtual-list-reporting-part-1/

PS: "It's been 4 days" is not as likely to get you many responses as a more descriptive title.

This may help..

Edited February 14, 20188 yr by Lola

The bottom line is: FileMaker doesn't have a native pivot feature, so you'll have to build it yourself, and there are various approaches you can take.