1 Reply Latest reply on Nov 6, 2018 7:38 PM by swaroop.gantela

    Comparing Employees total to matrix by location issue [HELP]


      Hi, I have the following issue and I attached an example on how my data is structured.

      I have two data sources, first one is list of employees with location and position(Oracle). the second is budget matrix with values for each location and position (Excel)

      Sample employees data:

      Matrix Data:

      So the problem is when creating a cross tab table to compare and show variance the matrix values that don't have and employee equivalent is ignored and I'm unable to create an accurate info see below:

      Any tip on how to solve this issue?