Newbies randsome Posted February 13, 2018 Newbies Share Posted February 13, 2018 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 Link to comment Share on other sites More sharing options...
Fitch Posted February 13, 2018 Share Posted February 13, 2018 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. Link to comment Share on other sites More sharing options...
Lola Posted February 14, 2018 Share Posted February 14, 2018 (edited) This may help.. Edited February 14, 2018 by Lola Link to comment Share on other sites More sharing options...
Fitch Posted February 14, 2018 Share Posted February 14, 2018 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2255 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now