Tabular Layout

[dave1]

Say I have two subsummaries, for the total hours worked. One is for Employee, and the other Month of the year

Is there a way to setup the layout so that the employees are the rows, and the months of the year goes across as the columns?

Below is what I'm trying to do.

eg..

---------| Jan | Feb | Mar | Total

Employee1| 50 | 2 | 24 | 76

Employee2| - | 1 | - | 1

Employee3| - | - | 12 | 12

---------------------------------

Total | 50 | 3 | 36 | 89

The layout of the months should be dynamic.

Thanks,

-dave

Edited April 5, 2007 by Guest

[Søren Dyhr]

As such are very likely to have landed here:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

But this is a little more cryptic to digest:

The layout of the months should be dynamic

Does this mean that arbitrary month's can be placed next to each other coloumnwise? In such a case must global fields be engaged (...sigh) to control the function:

http://www.filemaker.com/help/FunctionsRef-37.html

Well there might some trickery with the repeaters involved in Michails approach, that just come in handy?

--sd

[dave1]

When I mean dynamic I just mean that the data might start in feb, roll over into a different year and last only several months.

Edited April 9, 2007 by Guest

[Søren Dyhr]

Ok the later one of them, do you have enough information to go on, or do you need more guidance??

--sd

[dave1]

I'm still having some trouble with dynamic columns based on months. Can you offer any suggestions?

I've been trying to play around with repeating fields and the Extend function with no luck =

thanks,

dave

Edited April 11, 2007 by Guest

[Søren Dyhr]

Alright I've made you a template, which uses the principle from the original URL I mentioned ...I made a choise along the line where I got irritated by sequential numbering of global, that I would refrain from them in this case ...although it might be globals only if you're dealing in a multiuser environment.

Instead did I cut up a cartesian related portal, to make it display the coloumn headers. Since they're in the header area, are a script nessersary since only global fields can be changed up there. I choose to GTRR to get to each header label in the related table, with the feature to make something which could pass as a dialog box.

This lead to a revalation, even though you commit the record by the interrupted scripting won't it force a freshing through in the grand summary ...so more radical measures were needed! Now the measures I've taken to make the thing behave are probably way beyond whats nessersary. But what I did was to dupe each record and get rid of the original to un-tie the original stubborn references.

I'm pretty sure it can be done simpler! Meanwhile enjoy...

--sd

LabelizedSum.zip

[dave1]

Thanks for example, I tried to run it but I'm not seeing any totals appear for some reason.

Also my intention is not to allow the user to switch the ordering of the months.

The example you provided me was exactly what I was looking for, except that he manually layed out the columns Jan-Dec

What I'm trying to accomplish is that if my dataset only has dates in the months of June and July, I only want two columns to appear.

Thanks,

-dave

[Søren Dyhr]

Thanks for example, I tried to run it but I'm not seeing any totals appear for some reason

You mean farthest to the right?? No I havn't made them yet, poke into Michails description to see how they're made.

What I'm trying to accomplish is that if my dataset only has dates in the months of June and July, I only want two columns to appear.

Excellent challenge, await something tomorrow!

--sd

[Søren Dyhr]

Although there still are remaining layout issues, can it indeed be done - take a look!

What I here use is of course:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

Then do I use:

http://www.sumware.net/robfm/savingfoundsets.php

Which requires that the relational graph gets an addition ...and then:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

To make one occurrence of each relevant month to display. Beyond the import between tables in the same file, should the rest be similar to what i did in yesterdays template. Ah I nearly forgot - the merge fields offsets towards left, the label and the GetSummary results to the number of coloumns requirering display.

--sd

LabelizedSum2.zip