1 Reply Latest reply on May 1, 2018 9:26 AM by Deepak Rai

    Count across multiple dimensions

    simran singh

      Hi,

       

      I have the following data:

      column1column2
      AA
      AC
      AB
      BG
      CA
      DB
      EA
      FA
      GA
      GA
      GA
      GA

       

      I want to sum up the data as following:

      ABCDEFG
      count-col13111114
      count-col28110001

      From this data I want to plot a bar chart (either side by side or 2 bars for each category).

      I have tried using the count across both the dimensions but it always gives the same count for A, B, C, D etc.

       

      PS - the data source is not excel so I am unable to use pivot option.

       

      Any help is appreciated.

       

      Thanks.