7 Replies Latest reply on Oct 26, 2018 10:09 AM by Thanh Phan

    Extract data from different groups

    Thanh Phan

      Hi everyone,

       

      I am a newbie and struggling with the following problem. Due to confidentiality, I am not able to share a workbook, but I will describe the issue. Anyone could help out would be highly appreciated.

       

      Sales data of five different cities has been classified in 5 groups, with base and target values accordingly. In order to calculate a certain required ratio, I need to extract target value of group 1 and base value of group 5. I know that I need a calculated field to make this calculation. However, I don't know how to extract target value of group 1 and base value of group 5. Should I use a calculated field to extract target value of group 1 and another calculated field for base value of group 5? If so, what command should I use? Or are there any other better ways to do it?

       

      Thanks a lot for your advise.