The Crosstabulation Grid Editor displays in a crosstabulation format for up 10
files and allows manipulation of values for each column and/or mathematical
relationships between selected columns.For example, you may enter required
values for any of the following cells:
-
AS or PS sales or free goods units for any product
-
AS or PS % free goods units for any product
-
AS or PS total units for any product (maintaining current ratio between free
goods and sales)
The crosstabulation grid editor is likely to be of particular use in Starplan
databases when planning expenses by account and cost centre/BU. For example,
you would be able to enter annual forecasts values for any of the following:
-
Any account for any cost centre
-
Total for any account across all cost centres
-
Total for any cost centre across all accounts
-
Total for all cost centres for all accounts
