Jump to content

Retrieve Data From Crosstab Table


Recommended Posts

Hi,

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.

Kent

CrossTabInputExample.fmp12

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.