8 Replies Latest reply on Sep 17, 2018 11:12 PM by Nandan Kumar

    Base Revenue

    Nandan Kumar

      Hi Tableau Pros,

       

      I have created two calculated field with month on month view:

       

      1. Active Revenue : if {FIXED [Customer], Month([Date]):SUM([Revenue])}>100 then [Revenue] end

      2. Variable Revenue : if {FIXED [Customer], Month([Date]):SUM([Revenue])}>10000 then [Revenue] end

       

      Now I want to create a third field which will take month on month difference of these two. I have tried [Active Revenue] - [Variable Revenue] but it is not giving me correct result. Technically, base revenue and variable revenue should add upto active revenue but this is not the case. It is giving a sum > active revenue. Where am I failing? Need help techies.