# View: int_dbt_prod_transaction_country_report

**View Name:** int_dbt_prod_transaction_country_report
**Table Source:** `Derived from: Dbt_Prod_Strategy.Ifpi_Transaction_Country_Report, Intelligence.Dbt_Prod_Strategy`
**File Path:** `views/territory_kpis/int_dbt_prod_transaction_country_report.view.lkml`

## Overview

- **File Size:** 1825 bytes
- **Lines of Code:** 85
- **Dimensions:** 8
- **Measures:** 2
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `lastest_month_of_current_year` | number |
| `latest_year` | number |
| `label_country` | string |
| `transaction_country` | string |
| `local_global_transaction` | string |
| `label_id` | number |
| `label_name` | string |
| `activity_period` | string |

## Measures

| Name | Type |
|------|------|
| `net_revenue_usd` | sum |
| `gross_revenue_usd` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_month` | time |

## Derived Table

```sql
sql:
      SELECT
        *
      FROM intelligence.dbt_prod_strategy.ifpi_transaction_country_report
      ;;
```