3 Replies Latest reply on Oct 14, 2019 4:45 AM by Jim Dehner

    Fixing Client Percentage

    Vaibhav Saraf

      I've prepared a client profitability dashboard.  Data Sets includes:

      1.     Time charged by employee by day (Time-sheet)

       

      The Overheads (entered manually) is for the all the clients, I've divided the overheads on the basis of % proportion (Overhead Driver) of time charged for each client.

       

      Problem Statement:

      Overhead Driver remains 100% for all the clients, once I filter one client the overhead drivers also changes to 100% and the Overhead for whole region is shown for one client.

       

      i tried to use Fixed function but its not allowing.

       

       

      Please suggest an alternative.

       

      Thanks,

      Vaibhav