-----
TOP FOUR NUMBERS: 
(1)  Total Gross Revenue Last Month (Accounting2)
(2)  Target for This month  [Hard coded number  eg $6,686,524]
(3)  Forecasted Revenue This month (Analytics)
(4)  Total Releases this month (sales_start_Date is this month. From dim_release)
------

## iTunes Charts
(5) Total Gross Revenue Over time (Accounting2)
      BY Continent Group BY 18 month lookback
      https://theorchard.looker.com/x/GJjV8K3

(6) Albums vs Tracks
    (i'll work on this)

--------

## Top 10 Genres by Store  (in one horizontal view)
## Using Total_Gross_Revenue From ACCOUNTING2  database (not analytics)
(7) iRadio
(8) iTunes
(9) Spotify
(10) Amazon Digital Services Inc.

=========


iTunes
Spotify
YouTube
Amazon Digital Services Inc.
Google Music
Cricket Communications, Inc.
Rhapsody
eMusic
deezer
MediaNet

  - dimension: store_group
    sql_case:
      Amazon: ${storeid} in (419, 187, 376)
      YouTube: ${storeid} in (453, 45303, 45302, 45301, 463, 569, 312)
      iTunes: ${storeid} in (1, 445)
      iRadio: ${storeid} in (10001, 10003, 10002, 10004)
      Cricket: ${storeid} in (497)
      Google_Music: ${storeid} in (496)
      ${storeid}: ${storeid} in (11, 3, 4, 286, 348, 7, 424)
      else: "OTHER"