Jump to content

Retrieve Data From Crosstab Table

Recommended Posts


I am new to filemaker.  I have created a crosstab table and I like to retrieve data from it in another table.  For example,  in the layout, "RetrieveData",  I like to retrieve the activity name "Apple" in March, I like to get the value "24".  How I should approach it in the relationship.   

Many Thanks.



Link to post
Share on other sites

if your cross tab table is always going only have 12 months you could add a field and it could be calculated  

jan & ¶ & feb & ¶ & mar & ¶ & apr (etc all 12 months.)

Then once your name matches "Apple" via a relationship  just use GetValue ( data ; Month ( dateField  ) ) 

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.