2 entries table report with subsummary fields

[Beno]

Hi everybody !

I try to create a report showing subsummary results in a 2-entries table.

Let's say I'm selling products that have references as key identifier. I would like too have informations about the revenue I got with one product in one month. So this revenue is a subsummary per month AND product reference. I can easily have this result, but I can't find the way to present it in a table...

See the attached file for more details.

Help. Thank you

Result.txt

[RalphL]

This is called a Cross Tab. There is a set of sample files at <http://www.databasepros.com> under resourses.

[Beno]

For this, I would recommend a Report generator, such as FMC Table Pivot, available at http://www.fmcdn.com/

[Lee Smith]

Windows only!

[Beno]

Yop. Even worst : Office XP only. This is restrictive, but for those who have that configuration, it works fine. For the others, they should be something else... (

Version: v6.x

Platform: Windows XP