# View: physical_eu_stock_movement

**View Name:** physical_eu_stock_movement
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `physical_eu_stock_movement.view.lkml`

## Overview

- **File Size:** 4463 bytes
- **Lines of Code:** 163
- **Dimensions:** 3
- **Measures:** 18
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- UK Measures
- EU Measures

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | number |
| `label_id` | string |
| `upc` | string |

## Measures

| Name | Type |
|------|------|
| `uk_stock_total` | sum |
| `uk_stock_inbound` | sum |
| `uk_sales_this_month` | sum |
| `uk_sales_last_month` | sum |
| `uk_sales_this_year` | sum |
| `uk_sales_last_year` | sum |
| `uk_sales_total` | sum |
| `uk_is_deleted` | max |
| `eu_stock_total` | sum |
| `eu_stock_external` | sum |
| `eu_stock_backorders` | sum |
| `eu_stock_inbound` | sum |
| `eu_sales_this_month` | sum |
| `eu_sales_last_month` | sum |
| `eu_sales_this_year` | sum |
| `eu_sales_last_year` | sum |
| `eu_sales_total` | sum |
| `eu_is_deleted` | max |

## Derived Table

```sql
sql: SELECT *,

                CASE WHEN warehouse_id = 101 THEN stock_total ELSE 0 END AS uk_stock_total,
                CASE WHEN warehouse_id = 101 THEN stock_inbound ELSE 0 END AS uk_stock_inbound,
                CASE WHEN warehouse_id = 101 THEN sales_this_month ELSE 0 END AS uk_sales_this_month,
                CASE WHEN warehouse_id = 101 THEN sales_last_month ELSE 0 END AS uk_sales_last_month,
                CASE WHEN warehouse_id = 101 THEN sales_this_year ELSE 0 END AS uk_sales_this_year,
                CASE WHEN warehouse_id = 101 THEN sales_last_year ELSE 0 END AS uk_sales_last_year,
                CASE WHEN warehouse_id = 101 THEN sales_total ELSE 0 END AS uk_sales_total,
                CASE WHEN warehouse_id = 101 THEN is_deleted ELSE NULL END AS uk_is_deleted,

                CASE WHEN warehouse_id = 102 THEN stock_total ELSE 0 END AS eu_stock_total,
                CASE WHEN warehouse_id = 102 THEN stock_external ELSE 0 END AS eu_stock_external,
                CASE WHEN warehouse_id = 102 THEN stock_backorders ELSE 0 END AS eu_stock_backorders,
                CASE WHEN warehouse_id = 102 THEN stock_inbound ELSE 0 END AS eu_stock_inbound,
                CASE WHEN warehouse_id = 102 THEN sales_this_month ELSE 0 END AS eu_sales_this_month,
                CASE WHEN warehouse_id = 102 THEN sales_last_month ELSE 0 END AS eu_sales_last_month,
                CASE WHEN warehouse_id = 102 THEN sales_this_year ELSE 0 END AS eu_sales_this_year,
                CASE WHEN warehouse_id = 102 THEN sales_last_year ELSE 0 END AS eu_sales_last_year,
                CASE WHEN warehouse_id = 102 THEN sales_total ELSE 0 END AS eu_sales_total,
                CASE WHEN warehouse_id = 102 THEN is_deleted ELSE NULL END AS eu_is_deleted

         FROM ${physical_eu.SQL_TABLE_NAME
```