When you have defined the crosstab, you can see it with data in the Preview view.
To preview the crosstab:
If the Preview view is not open, select View>Preview from the menu bar to display the Preview view.
Click on the Preview view to be sure it is current.
Select Rows>Retrieve from the menu bar.
PowerBuilder retrieves the rows and performs the cross tabulation on the data.
Continue enhancing your DataWindow object and retrieve again when necessary to see the results of your enhancements.