Hi all -

I am working with two dimensions - Order Status and Delivery Date. I need to generate a report that will provide the following type of output...

......................Dt1.......Dt2.......Dt3.......Dtx... Ttl

Order Stat1.....50.......25.......20.......15.......110

Order Stat2 ....30.......20.......17.......19.......86

Order Stat3 ....43.......29.......30.......5.......107

Order StatX.....21.......13.......42.......74.......150

Total...........144.......87.......109.......103

Any advice on how to do this in FM? Is export to Excel my only hope?

Thanks!

You can do pivot table-like things with sub summaries. Though they can only go downwards, not across the page.

Thanks for the tip. I'll give it a whirl...

Well, actually you can, but it is a lot of tedious work. Check out this thread and carefully read LiveOak's response. I have done it, and I agree it is not trivial.

Mike