6 Replies Latest reply on Jan 28, 2017 11:54 PM by Paris B

    How to create to show aggregate value for each year

    Paris B

      My data looks like Table A. I pivoted 24 months into two columns - date and revenue.

      Now I want to create charts below, I tried multiple ways but no success so far. I would appreciate any help.

       

      Table A

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Col A

      Jan-15

      Feb-15

      Mar-15

      Apr-15

      May-15

      Jun-15

      Jul-15

      Aug-15

      Sep-15

      Oct-15

      Nov-15

      Dec-15

      Jan-16

      Feb-16

      Mar-16

      Apr-16

      May-16

      Jun-16

      Jul-16

      Aug-16

      Sep-16

      Oct-16

      Nov-16

      Dec-16

      Col B

      Col C

      A

      1

      2

      3

      4

      5

      6

      7

      8

      9

      10

      11

      12

      37

      38

      39

      40

      41

      42

      43

      44

      45

      46

      47

      48

      p

      d

      B

      13

      14

      15

      16

      17

      18

      19

      20

      21

      22

      23

      24

      49

      50

      51

      52

      53

      54

      55

      56

      57

      58

      59

      60

      q

      e

      C

      25

      26

      27

      28

      29

      30

      31

      32

      33

      34

      35

      36

      61

      62

      63

      64

      65

      66

      67

      68

      69

      70

      71

      72

      r

      f