# View: KNR_Performer_Run_Delivered_Societies

**View Name:** KNR_Performer_Run_Delivered_Societies
**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_Societies.view.lkml`

## Overview

- **File Size:** 1012 bytes
- **Lines of Code:** 41
- **Dimensions:** 3
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Batch_ID` | string |
| `Store_ID` | string |
| `Store_Name` | string |

## Measures

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

## SQL Comments

- st.customer_name

## Derived Table

```sql
sql:
select
nr.batch_id,
nr.store_id,
st.customer_name,
round(sum(nr.TOTAL_USD),5) total_usd,
round(sum(nr.WITHHOLDING_TAX_USD),5) wht_usd
--st.customer_name
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
      ;;
```