5 Replies Latest reply on Jul 15, 2015 1:14 AM by Felix Curran

    How to generate a report with splitting the different values in one dimension with calculation?

    Yuan Zhao

      I have the data set like

       

         

      Product NameProduct StatusCreate Date
      P1OrderedD1
      P1CancelledD2
      P1OrderedD3
      P1DeliveryD4
      P2OrderedD5
      P2DeliveryD6
      P2ReceivedD7
      P3OrderedD8
      P3CancelledD9
      P4OrderedD10
      P4DeliveryD11
      P3OrderedD12
      P4OrderedD13
      P4DeliveryD14
      P4ReceivedD15
      P1DeliveryD16
      P2OrderedD17
      P1DeliveryD18
      P2CancelledD19
      P3OrderedD20
      P4OrderedD21

       

      And I want to use tableau to finally get such display with calculating cancel / Order rate

            

      Product NameCancelledDeliveryOrderedReceivedCOR
      P1132 50%
      P2112150%
      P31 3 33%
      P4 2310%

       

      Any idea?