>Hi All,
>
>I am looking for suggestions:
>
>I need to calculate multiple outputs for multiple years for multiple items and so I will end up with a 3 dimensional grid of data. Obvioulsy a grid can only show 2 dimensions and so normally one chooses the X & Y axis from the possible 3 dimensions and holds the 3rd dimension on some static value. I can program a form with multiple tabs each with a grid, or allow the user to choose the X & Y axis and fix the 3rd dimension. But does anybody have any other clever or cool suggestions on how to display such a data array? Any nice 3D reporting OCXs out there?
>
>TIA

Sounds like Excel's pivot.
Cetin