1 Reply Latest reply on Apr 12, 2016 12:54 AM by Manideep Bhattacharyya

    Blend within a line (on Excel) using 2 date-parameters

    Paul Noras

      Hi Tableau community~

       

      I am trying to blend data based on date (MM-YYYY) for my fraud/non fraud analysis.

      Basically when we get charegeback, we categorize them as fraud/non fraud and then analyze them by transaction month and partner

      So, if a charge-back and reversal happen in one month, I have 1 line with 2 different dates, if happen in a different month, I would have 2 lines.

       

      I would like to have a table (column : each month) and lines (CB amount and CB amount reversal by partner) but have been struggling to make this happen.

      Could I please get some directions

       

      Questions:

      • How can I get the net of chargeback (CB - CB Reversal) for each partner?
      • How can I get a column subtotal on the partner level?

       

      Many many thanks

       

      This is what I would like to see

      June-2015
      July-2015Aug-2015
      100020002300
      -300-1200-2900