3 Replies Latest reply on Feb 26, 2018 9:40 PM by Peter Fakan

    Data Blending

    Barb Reiser

      Hi all,

       

      I'm working off two excel sheets. I'm trying to get the total entries from both sheets onto one sheet. If you look at the attachment, you'll see I have 8 entries for Africa for December. My 2nd sheet I only have 2 entries for Africa in January. I've tried the data blending but I can't seem to get it to work. My ultimate goal is to use the measure "Calc" to show the % for each month by location. Can this be done?

       

      Thank you,

      Barb