1 Reply Latest reply on Jul 19, 2016 3:01 PM by Adam Cogswel

    Need help with this view

    Nikil Babu

      Hi Guys,

      Please help me with this view which i am trying for a long time now

      let me know if it is possible

       

      I have the data in the following format (attached in the file )

          

      ProgramDivisionRegion     YearPeriodWeekProject
      AdventureWalt DisneyA201684Star Wars Ep. VII: The Force Awakens
      ActionUniversalB2017123Jurassic World
      ActionWalt DisneyC201852The Avengers: Age of Ultron
      AdventureWalt DisneyA201612Inside Out
      ActionUniversalB201713Furious 7
      DramaWarner Bros.C201894American Sniper
      ComedyUniversalA201671Minions
      Thriller/SuspenseLionsgateB201752The Hunger Games: Mockingjay - Part 2
      Thriller/Suspense20th Century FoxC201831The Martian
      DramaWalt DisneyA201634Cinderella
      ActionSony PicturesB201741Spectre
      ActionParamount PicturesC2018123Mission: Impossible - Rogue Nation
      ComedyUniversalA2016112Pitch Perfect 2
      ActionWalt DisneyB201764Ant-Man
      Adventure20th Century FoxC201832Home
      ComedySony PicturesA201673Hotel Transylvania 2
      DramaUniversalB2017134Fifty Shades of Grey
      ComedyParamount PicturesC201852The SpongeBob Movie: Sponge Out of Water
      DramaUniversalA201662Straight Outta Compton

       

      i am not able to get the required view (below)

          

                    Total by year                            2016             2017
      DivisionRegionProgram201620172018     p1 p2 ....p1 p2 ......
      Walt disneyAAdventure312 Jurassic World
      Fiction100 American Sniper
      BAdventure345 The Avengers: Age of Ultron
      Drama123 The Martian Ant-Man
      CComedy4 7