45 Replies Latest reply: Jul 31, 2017 11:05 AM by Sunny Talwar RSS

    Question on Pivot Table % Calculation

    Gopi Krishna

      I want to create a Dashboard with Monthly % calculation by task, By monthwise and Yearwise based on Task Completion Time. I Created a Piovt Table with my data, but the % values are not coming correctly.

      Here iam attaching the datewise date, based upon data we need to calculate the Monthwise reload completion  % and yearwise reload completion % Value.

      Please help me how to calculate the % calculation by Monthly and yearly for each task.