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

    First & Last Function


      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.