Good Morning,

Just when I think I'm getting somewhere...It's back to where the true knowledge is!

I have a set of data where my boss is asking for a report that if it is possible in FMP I don't have the slightest idea how to do it. In Excel, this type of report (Pivot table) is a snap.

My Fields are:

Customer2 (GreenGrass, Corporate, Retail, BigBox, etc.....)

deLogo (I need to create a sumField Count of deLogo)

the Months will display the Count of deLogo.

I Then need to build a report that looks something like this:

.................January.....February.....March.....Etc.

GreenGrass.100..........132............432........999

Corporate...73............98..............173........333

Retail.........987...........1232.........1578.......2342

BigBox........831...........1173.........1433.......2763

Is this possible to do in FMP or do I have to take the result of a typical summary report and export to Excel?

Steve

Edited June 15, 200718 yr by Guest

Steve,

See if these threads help you.

Pivot table

Edoshin's Crosstab