Intensity Metrics in Pivot Tables - contextualize your data instantly

Ricardo Méndez Escobar avatar Ricardo Méndez Escobar · · 2 min read
Intensity Metrics in Pivot Tables - contextualize your data instantly

Photo by Trac Vu on Unsplash

Ever wanted to see your emissions per euro of revenue, per employee, or per tonne handled, without leaving your pivot table? Now you can.

We have added Intensity Metrics to pivot tables: choose any emissions metric as the numerator, select an intensity group (revenue, FTEs, production volume…), and get an automatically calculated normalized ratio in every row and column.

How it works

  1. Open any pivot table (Carbon Footprint, Waste, or Energy)
  2. Click Add intensity metric in the measures panel
  3. Choose your numerator metric (e.g. kg CO2 eq, waste quantity, or energy consumed) and the activity data to build the intensity metric
  4. If you don’t have data yet, go to Data > Customize > Intensity metrics and create groups and add data
  5. The table instantly displays the combined ratio with a clear unit label (e.g. kgCO2e / EUR) Why it matters
  • Measure your company’s efficiency — if your company grows, emissions usually grow too, but are the sustainability team’s efforts paying off? Now you can measure it
  • Easy benchmarking — compare sites, periods, or business units on equal footing
  • Contextualization — an essential step for your ISO 14001, 45001…
  • Report-ready ratios — export to Excel with exactly the layout you see on screen
  • Decarbonization plans — intensity metrics are a must-have
  • No manual calculations — the platform handles unit conversion, period matching, and fiscal year alignment
  • Missing data? No problem — cells without intensity values are clearly flagged with a link to add the data Works with monthly, quarterly, and annual granularity, including fiscal year support.

Tip: add monthly values from the first to the last day of the month with your activity data to get the most out of it.

Built for: GHG Protocol · CSRD · ISO 14064 · Internal KPIs · Sustainability Reporting

It’s already available in your account. Give it a try and let us know what you think — your feedback helps us keep improving.

Product UpdateDataVisualization

Need expert guidance?

Dcycle combines automation with hands-on advisory to simplify your compliance.

Talk to our team

Collect once. Use everywhere.

See how Dcycle can cut your reporting time by 70% and give your auditors what they need , the first time.

See Dcycle in action