2 Replies Latest reply on Jan 7, 2017 12:45 AM by Chandra Bhaskar

    First & Last Function

    koushik.neelakantha

      Hello everyone,

       

      I have used below logic to hide Row level values in my workbook.

       

      Calculated 1: if first() = last () then AVG([ Last 12 Months Sales]) end

       

      As I am taking AVG in the calculated field, I need to get SUM for totals and grand total.

       

      But the TOTAL USING  Option is disabled. How to enable it? Please help me out.

       

      Note: If i use SUM in the calculated field, I am getting Wrong values.

       

      Regards,

      Koushik.