# View: dt_top_5_countries

**View Name:** dt_top_5_countries
**Table Source:** `Derived from: Prod.Dim_Country, Prod.Workstation_Fact_Sales_Unified_Dbt, Royalty_Accounting, Royalty_Accounting.Prod`
**File Path:** `dt_top_5_countries.view.lkml`

## Overview

- **File Size:** 1669 bytes
- **Lines of Code:** 58
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `country_name` | string |

## Measures

| Name | Type |
|------|------|
| `net_revenue` | max |

## Filters

- `filter_accountingyear`

## Derived Table

```sql
sql: WITH top_5_countries AS (
      SELECT
          dc.countryname AS country_name,
          SUM(fs.net_receipt) AS net_revenue
      FROM royalty_accounting.prod.workstation_fact_sales_unified_dbt fs
      LEFT JOIN facts.prod.dim_country AS dc ON fs.countryid = dc.countryid
      WHERE fs.labelid = {% parameter filter_label_id %
```