2 Replies Latest reply on Apr 7, 2016 2:49 AM by Yuri Tupizin

    Aggregation over table calculation

    Yuri Tupizin

      Hi,

      I'm using Tableau 9.0, my data source is salesforce.

      My Data looks like this :

      for each account I know the cash flow ($) for each year.

      Untitled.png

      I would like to calculate "Dead Account" the in the following way : if running total over the "total cash flow ($)" hits 0 ( = 0 ) then

      "dead account" = 1 else = 0.

      Now I would like to aggregate "Dead Account" by year  and get something like this :

      2013 - 20 dead accounts

      2014 - 53 dead accounts

      and so on...

       

      I know that 2nd aggregation over table calculation is blocked in Tableau, so basically I'm looking for some hack

       

      Any ideas would be great.

      Thanks,

      Yuri