Yuri, bom dia!
Apenas registrando aqui a resposta que tive de um outro colega e que funcionou perfeitamente.
This worked for me:
- Include all of the fields you want to use to filter in the load of Step_1
- Specify all filtering fields in the group by syntax of Step_1.
- Include number of filtering fields in crosstable syntax of Step_2
Using Rangaraju R's example the updated script for Step_1 and Step_2 for two filters - Year and Quarter - would be:
SUM(REV_A) as Rev_A,
SUM(REV_B) as Rev_B,
SUM(REV_C) as Rev_C,
SUM(COGS) as COGS,
SUM(EXPENSES) as Expenses,
SUM(LOSS) as Loss,
SUM("NET INCOME") as [Net Income]
Resident Dynamic_Data Group By "YEAR", "Quarter";
Drop Table Dynamic_Data;
Load * Resident Step_1;
Drop Table Step_1;