---
title: "Discussion on \"Adobe Commerce to Looker Studio: SUM(grand_total) Is Not Revenue\" | Hashnode"
description: "Discussion on \"Adobe Commerce to Looker Studio: SUM(grand_total) Is Not Revenue\". Run against a fake store, the Orders tab from the usual recipe keeps cancelled orders as pending and adds euros to dollars. A row that carries net revenue in base currency, and a check against the store."
url: "https://hashnode.com/posts/adobe-commerce-to-looker-studio-sum-grand-total-is-not-revenue/6ada4b76e45e5683bfa0e3a2"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Adobe Commerce to Looker Studio: SUM(grand\_total) Is Not Revenue](https://magesheet-team.hashnode.dev/adobe-commerce-to-looker-studio-sum-grand-total-is-not-revenue?utm_source=hashnode&utm_medium=feed)

Run against a fake store, the Orders tab from the usual recipe keeps cancelled orders as pending and adds euros to dollars. A row that carries net revenue in base currency, and a check against the store.

Oct 22 · 12 min read · magesheet-team.hashnode.dev  
Read the article

-   [#magesheet](https://hashnode.com/tag/magesheet)
-   [#adobe-commerce](https://hashnode.com/tag/adobe-commerce)
-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#looker-studio](https://hashnode.com/tag/looker-studio)
-   [#google-apps-script](https://hashnode.com/tag/google-apps-script)

## Written by

[Hayrullah Kar](https://hashnode.com/@magesheet)

@magesheet · Sakarya,Turkey

  
[View profile](https://hashnode.com/@magesheet)

Founder & Automation Strategist @MageSheet | Google Apps Script & AI Specialist.

Founder &amp; Automation Strategist @MageSheet. I specialize in building intelligent automation systems and custom CRMs using Google Apps Script and AI to eliminate manual workflows and drive business efficiency.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
