Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got a problem using P&L Chart. Could anyone kindly help?
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!
@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
... )
@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
... )
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:
Thank you for your answer. But I need valuelist to create manuelly subsum (e.g. Revenue + COGS).
Huge thanks for quick answer.