1 2 Previous Next 27 Replies Latest reply on May 21, 2017 4:08 PM by parvinder.bindra.0 Branched to a new discussion.

    Table Calculation Callenge

    parvinder.bindra.0

      Hi All,

       

      I am struggling with a table calculation question where the input data is pasted along with the respective output.

      1 ) The objective is to find the distinct count of values in the Category and Manufacture columns based on Region and Segment columns.

      I am able to perform the calculation on Category and Manufacturer on Separate sheets, but unable to do them while having them in same sheet as two columns.

       

      2) Distinct count of first two columns (Region, Segment) and displaying at the bottom of string columns also seems pretty challenging to me.

      Please help me resolve this.

       

      Thank you in advance,

      Parvinder

       

      Output Expected from input data

          

      RegionSegmentCategoryManufacturer
      EastConsumer34
      Head Office23
      NorthConsumer11
      Corporate11
      Regional Office21
      Branch Office11
      SouthHead Office33
      351314

       

       

       

       

      Input data to the workbook

         

      RegionSegmentCategoryManufacturer
      EastConsumerFurnitureAdams
      EastConsumerTechnologyApple
      EastConsumerTechnologyATnT
      EastConsumerTechnologyApple
      EastConsumerOffice SuppliesBelkein
      EastHead OfficeTechnologyCanon
      EastHead OfficeOffice SuppliesXerox
      EastHead OfficeOffice SuppliesStorex
      NorthConsumerTechnologyCisco
      NorthCorporateTechnologyCanon
      NorthRegional OfficeOffice SuppliesUniversal
      NorthRegional OfficeTechnologyUniversal
      NorthBranch OfficeTechnologyWirebound
      SouthHead OfficeTechnologyApple
      SouthHead OfficeOffice SuppliesXerox
      SouthHead OfficeFurnitureXerox
      SouthHead OfficeFurniture

      Adams

        1 2 Previous Next