# View: fact_sales_releases_aggregated

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

## Overview

- **File Size:** 1914 bytes
- **Lines of Code:** 71
- **Dimensions:** 4
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Comments & Notes

- subquery for grouping releases

## Dimensions

| Name | Type |
|------|------|
| `releaseid` | number |
| `sum_gross_rev` | number |
| `sum_streams` | number |
| `sum_net_rev` | number |

## Measures

| Name | Type |
|------|------|
| `count_labelid` | count_distinct |

## Filters

- `activity_date`
- `transactiontypeabbr`

## Derived Table

```sql
sql:
      select releaseid
            , sum(gross) as sum_gross_rev
            , sum(sales) as sum_streams
            , sum(net_receipt) as sum_net_rev
      from royalty_accounting.prod.workstation_fact_sales_unified_dbt fs
      left join facts.prod.dim_transactiontype dt on dt.transactiontypeid=fs.transactiontypeid
      where {% condition activity_date %
```