1 Reply Latest reply on Nov 30, 2015 10:46 AM by Matt Arnold

    Blending Actives, Terms and Hires Data

    Raj CH

      Hi Team,

      I am working on HR data in which I get Hires, Actives and Terms data from three different data sources, while using therm on Dashboard I take Actives as my primary data source for all worksheets to make filters work on all worksheets, however when I am blending all the three source data, there are few values in Terms but not in hires and vice versa so when i pull the numbers to dashboard i get less numbers than expected.

      what can be the possible workout to get numbers reflect as in my data-source ( i have tried using ZN() but it did not seems to work)