Pivot Table behavior in FM?

[coldspring]

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!

[falkaholic]

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

[coldspring]

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

[Mike D.]

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