Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TOP1 = CALCULATE(MAX(data[Value]);
- FILTER(ALLEXCEPT(data;data[Company];
- data[Year] = data[Year]
- && data[Branch] = data_segmento_anual[Branch]
- && data_segmento_anual[Group] = data_segmento_anual[Group]
- && data_segmento_anual[Bond] = data_segmento_anual[Bond]
- && data_segmento_anual[Type] = data_segmento_anual[Type]))
- YEAR COMPANY BRANCH GROUP Value TOP1
- 2016 BANCO DO BRASIL RISK RETAIL 4061567 4061567
- 2016 BANCO DO BRASIL ACUM RETAIL 1901920 1901920
- 2017 BANCO DO BRASIL RISK CORPORATE 439499 439499
- 2017 BANCO DO BRASIL RISK RETAIL 356231 356231
- 2016 BRADESCO RISK CORPORATE 347369 347369
- 2016 BANCO DO BRASIL RISK RETAIL 310920 4061567
- 2016 BANCO DO BRASIL ACUM CORPORATE 12091 12091
- 2016 BANCO DO BRASIL RISK RETAIL 1021 4061567
- 2017 BANCO DO BRASIL RISK CORPORATE 446 439499
- YEAR COMPANY BRANCH GROUP Value TOP1 TOP2
- 2016 BANCO DO BRASIL RISK RETAIL 4061567 4061567 310920
- 2016 BANCO DO BRASIL ACUM RETAIL 1901920 1901920 NA
- 2017 BANCO DO BRASIL RISK CORPORATE 439499 439499 446
- 2017 BANCO DO BRASIL RISK RETAIL 356231 356231 NA
- 2016 BRADESCO RISK CORPORATE 347369 347369 NA
- 2016 BANCO DO BRASIL RISK RETAIL 310920 4061567 310920
- 2016 BANCO DO BRASIL ACUM CORPORATE 12091 12091 NA
- 2016 BANCO DO BRASIL RISK RETAIL 1021 4061567 310920
- 2017 BANCO DO BRASIL RISK CORPORATE 446 439499 446
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement