3 Replies Latest reply on May 17, 2018 5:44 AM by Anupam Mehta

    How to calculate grand total by using calculated field??

    shikha agrawal

      I have one report. In this we are calculating grand total of Beginning balance from analytics option available in tableau. But we want a condition that if grand total is less than 100 then it should show blank otherwise report will show the grand total. Please tell me how can I do this.

       

      Ex. Beginning balance        End balance

               4000                            8000

        5000                                   7000

              6000                               5000

      Grand total :15000                 21000

       

       

       

      now if beginning balance is less than 100 then it should show blank otherwise it should show grand total.