Skip to main content
Question

Include ratio calculationbased on multiple dimensions

  • April 25, 2025
  • 2 replies
  • 78 views

Forum|alt.badge.img+2

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 ?

2 replies

Forum|alt.badge.img+2
  • Author
  • Apprentice Author
  • 5 replies
  • April 28, 2025

Anyone with an answer ?


Forum|alt.badge.img+4
  • Employee
  • 23 replies
  • April 28, 2025

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!