The crosstab is generated based on two Group by selected. When business users select Region, then product line, crosstab will be generated accordingly.
First value prompt
Second value prompt
In case when we don’t want to have second group, we can put ‘None’ there to indicate that no group by 2. The style variable can be used to suppress group by 2 in report. Please note that quotation mark is needed for use value as ‘None’, as it is considered as constant when querying .
The key to make this simple report flexible is to apply prompt token
#prompt ('pGroupBy1','token')# and
Style variable is defined as below
It will apply for both member and crosstab cell.