5 Replies Latest reply on Feb 29, 2016 3:19 PM by Romil Shah

    How to create a calculated field containing aggregated function

    Romil Shah

      Hi,

       

      I am creating different views for different countries.

       

      Each view(worksheet) contains last 3 year revenue by region for each country, which is divided by total no of working days for corresponding year in USA.

       

      For e.g. First View is USA, Second is UK and Third View is Russia.

       

      First view - Columns would be "Total Revenue in USA in 2013" , "Avg Daily Revenue in USA in 2013", "Total Revenue in USA in 2013=4" , "Avg Daily Revenue in USA in 2014", "Total Revenue in USA in 2015" , "Avg Daily Revenue in USA in 2015".

       

      Here, Avg Daily Revenue= Total Revenue / No of working days in USA for that period

       

      Similarly, for second view -  "Total Revenue in UK in 2013" , "Avg Daily Revenue in UK in 2013", "Total Revenue in UK in 2013=4" , "Avg Daily Revenue in UK in 2014", "Total Revenue in UK in 2015" , "Avg Daily Revenue in UK in 2015".

       

      Here, Avg Daily Revenue would again be = Total Revenue / No of Working days in USA for that period (even though the country is different now).

       

      Hence I would be using "Total No of Working days in USA" in many worksheets. How do i create a calculated field which can be used across many views?