topic Re: Measures for 2 dim - P&L Chart in App Development

Measures for 2 dim - P&L Chart

yali — Sat, 16 Nov 2024 18:10:03 GMT

I got a problem using P&L Chart. Could anyone kindly help?

The first column was created by valuelist, e.g. Gross Margin = Revenue + COGS.
The second dimension in this P&L Chart (A,B,C,D) is shown in the first row.
The measure is calculted by

pick(rowno(),
Sum({<ProfitLoss={'Revenue'}>}Amount),
Sum({<ProfitLoss={'COGS'}>}Amount),
Sum({<ProfitLoss={'Revenue','COGS'}>}Amount)....

The problem is the Revenue of A will be shown in the column of A. Under the column of B, I have COGS everywhere. (Please refer to the screenshot below).

What should I do to have the result like help document?

Many thanks!

Re: Measures for 2 dim - P&L Chart

Kushal_Chawda — Tue, 01 Sep 2020 13:28:41 GMT

@yali You may need to modify your expression like below

pick(Match(valuelist('Revenue','COGS',....),'Revenue','COGS',......),
Sum({<ProfitLoss={'Revenue'}>}Amount),
Sum({<ProfitLoss={'COGS'}>}Amount),
Sum({<ProfitLoss={'Revenue','COGS'}>}Amount

... )

Re: Measures for 2 dim - P&L Chart

AbhijitBansode — Tue, 01 Sep 2020 13:34:56 GMT

Just wondering the use of valuelist in this case. Not sure if you actually need it. You have below output if you use pivot table:

With below settings:

Re: Measures for 2 dim - P&L Chart

yali — Tue, 01 Sep 2020 13:38:28 GMT

Thank you for your answer. But I need valuelist to create manuelly subsum (e.g. Revenue + COGS).

Re: Measures for 2 dim - P&L Chart

yali — Tue, 01 Sep 2020 13:38:51 GMT

Huge thanks for quick answer.