Pivot Table with two dimensions and formulas for each case

GuilhermeSchneider — Sat, 16 Nov 2024 17:26:24 GMT

I cannot expand the Formulas in a pivot table.

I made a Load Inline to create this two dimensions, here is the code:

Valores_Financeiro:
LOAD * INLINE [
'Tipo Valor', 'Medida', 'Fórmula Financeiro'
'Receita', 'Descontos Obtidos', "vReceitas Descontos Obtidos"
'Receita', 'Juros Auferidos', 'vReceitasJurosAuferidos'
'Receita', 'Outras Receitas Financeiras', 'vReceitasOutrasReceitasFinanceiras'
'Receita', 'Ganhos Oper. Renda Variável', 'vReceitasRendaVariavel'
'Receita', 'Variações Monetárias Ativas' , 'vReceitasVariacoesMonetarias'
'Receita', 'Variações Cambiais', 'vReceitasVariacoesCambiais'
'Receita', 'Outras Receitas Operacionais', 'vReceitasOutrasReceitasOperacionais'
'Despesa', 'Bancárias'
'Despesa', 'Monetárias Passivas'
'Despesa', 'Arredondamento Mercantil'
'Despesa', 'Juros Pagos'
'Despesa', 'Bancárias Exportação'
'Despesa', 'Variações Cambiais'
'Despesa', 'Perda Renda Variável'
];

Here is what happens:

I need to expand the formulas, thought it was just put $([Fórmula Financeiro]) in measures but it doesn't work.

With ValueList i can make this work but than if you select it doesn't select in the right way than for me it doesn't work, i need in this way because than the user can select and then it will filter.

Obs: this variables contains the formulas

Example: vReceitasDescontosObtidos contains Sum([Receitas Descontos Obtidos]/1000)

Re: Pivot Table with two dimensions and formulas for each case

Anil_Babu_Samineni — Sat, 27 Feb 2021 19:22:12 GMT

Make sure that all variables measure fields are associated to any fact table? If so, can you post with example to verify?

topic Pivot Table with two dimensions and formulas for each case in App Development

Pivot Table with two dimensions and formulas for each case

Re: Pivot Table with two dimensions and formulas for each case