7 Replies Latest reply on Aug 22, 2018 1:47 PM by Ken Flerlage

    Count Rows based on same value(s) found in 2 columns

    Yasir Ali

      I have a dataset with 2 columns:

      A    B   Balance

      18  26    25

      26  25    50

      26 17     75

      19 26     50

      29 18     100

       

      I want to be able to create a pivot table where I can group (and count, sum etc)  on a calculated field which treats values in column A or B as the same. For example, resulting pivot will look like the following:

       

      AorB      count  sum(Balance)

      17              1         75

      18              2         125

      19              1          50

      25              1          50

      26              4          200

       

      Please help!!!!