10 Replies Latest reply on Dec 4, 2018 7:22 AM by Norbert Maijoor

    How to exclude a sub category value in (Grand)Totals while displaying in the view?

    Rao P

      How to exclude a sub category value in (Grand)Totals while displaying in the view?

       

      I want to show Nevada's profit in the view but want to exclude in Total

       

         

      CountryStateProfit
      USANew York$1,000
      New Jersy$1,000
      Texas$3,000
      California$1,000
      Nevada$5,000
      USA Total $6,000but not $11000
      UKLondon$1,000
      Manchester$2,000
      Total$3,000

       

      Thanks,

      Rao