Skip to main content

Hello,

I have a metric that shows the P&L.

I’ve been asked to add multiple ratios like % of GM / Revenue or % Contributive Margin / Revenue. The issue is that the accounts are not on the same dimension (revenue is Account lvl 2 and Gross Margin is Account lvl 3).

What is the easyest way to add those ratio. Do I need to create a specific metric just for them or can I do the calculation directly in my metric ?

Anyone with an answer ?

Hi ​@FranckLP hope all is well.

You may need to create a specific metric for them and add them into the pivot to make your adjustments. Feel free to use the article below as an example:

Let us know if this helps or not, thanks!

Reply


Ask your question here!

Terms & ConditionsCookie settings