2 Replies Latest reply on Jun 13, 2018 6:30 AM by Zhouyi Zhang

    Make a table which contains the filtered and non-filtered data

    Pak Hang  Leung

      Hi all

       

      Now we are working with a SQL table and the detail are as follows:

      Traffic typeTraffic sourceCoupon codeDate
      VisitRevenue
      SEOGoogleCoupon0012018-03250030000
      SEOBingCoupon0022018-03100015000
      SEOYahooNone2018-035008000
      SEOGoogleNone2018-02150020000

       

      To make a quick overview for the audience, I want to make a table (either in the dashboard or in the worksheet) to show the detail as follows

      Statistics With coupon codeTotal sum% to total
      Visit3500500070%
      Revenue450007300061%

       

      I tried to make it in the worksheet, but seems that I cannot create another column which exclude the original filter...

      Does anyone know how can I make it in the dashboard? Many thanks!

       

      Regards

      Pak Hang