6 Replies Latest reply on Nov 2, 2018 9:42 AM by Deepak Rai

    Simple Q: Crosstab column averages please

    Melissa Fanucci

      I know this must be easy, but I can't figure out how to get it to work. I need to average the annual exchange rate value by year. I want to have a simple total column that just lists the annual Average (see image below). Any ideas? Workbook attached. Thanks so much in advance for any help you can provide!

       

      Melissa

      rates.png