# View: KNR_Performer_Run_Delivered_Contributors

**View Name:** KNR_Performer_Run_Delivered_Contributors
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Stmt_Db_Sales_Nr + 2 more`
**File Path:** `views/KNR_Performer_Run_Delivered_Contributors.view.lkml`

## Overview

- **File Size:** 1172 bytes
- **Lines of Code:** 45
- **Dimensions:** 4
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Batch_ID` | string |
| `Contributor_ID` | string |
| `Contributor_Name` | string |
| `Store_Name` | string |

## Measures

| Name | Type |
|------|------|
| `Sum_Total_USD` | sum |
| `Sum_Total_WHT` | sum |

## Derived Table

```sql
sql:
      select
nr.BATCH_ID,
nr.contributor_ID,
nr.CONTRIBUTOR_NAME,
st.customer_name,
sum(nr.TOTAL_USD) total_usd,
sum(nr.WITHHOLDING_TAX_USD) WITHHOLDING_TAX_USD
from royalty_accounting.prod.stmt_db_sales_nr nr
 join orchard_app_reporting_v2.art_relations_prod_art_relations.country cn on cn.id=nr.country_id
 join orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master st on st.customer_master_master_id = nr.store_id
group by 1,2,3,4
            ;;
```