3 Replies Latest reply on Nov 23, 2017 6:27 PM by venkata siva prasad k

    LOD / Calculated Field Help

    Kim Wee

      Hi,

       

      I have a table similar to below:

         

      TypeOnline/OfflineAmountCount
      US DomesticOnline61
      US DomesticOnline6.51
      US DomesticOffline101
      US DomesticOffline111
      US DomesticOffline101
      UK DomesticOnline61
      UK DomesticOnline6.751
      UK DomesticOffline111
      UK DomesticOffline101
      UK DomesticOffline121

       

      I'm trying to create a couple of calculations but couldn't figure out what is the best option. I know I can put them into table and do table cal but I'm trying to avoid that.

       

      1) The different between online and offline amount for US Domestic (average online - average offline)

      2) The online % for US Domestic

       

      Can anyone help? I think LOD might be able to solve it but not very family with it.

       

      Thanks,