# View: dt_top_5_stores

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

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `store_name` | string |

## Measures

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

## Filters

- `filter_accountingyear`

## Derived Table

```sql
sql: WITH top_5_stores AS (
      SELECT
          ds.storename AS store_name,
          SUM(fs.net_receipt) AS net_revenue
      FROM royalty_accounting.prod.workstation_fact_sales_unified_dbt fs
      LEFT JOIN facts.prod.dim_store AS ds ON fs.storeid = ds.storeid
      WHERE fs.labelid = {% parameter filter_label_id %
```