Forum Discussion

manoplaeli's avatar
manoplaeli
Icon for Helper II rankHelper II
9 years ago
Solved

Quick calc percentage monthly

  I am working on employee time and I use quick Calc to show percentage but it show as total as in in the picture. I want to show the percentage of Direct vs Share by monthly. As you c...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi manoplaeli

     

    I think I misunderstood your problem initially.

     

    I have partially used Query Editor to get the correct results.

     

    I have pivoted the hours column to get the correct data structure in order to solve this problem. There are other solutions as well but I find this convenient.

    Pivot

    Then I have created 3 calculated columns to get the Share and Direct % as shown below.

    Results of the pivot columnSHARE%

     

     

manoplaeli's avatar
manoplaeli
Icon for Helper II rankHelper II
9 years ago

Thanks, BhaveshPatel

 

Below is the fomular in my table. It only show me Direct Cost.

 

 

DirectHours = CALCULATE(SUM('Timesheet Details TSR01'[Hours]),FILTER('Timesheet Details TSR01','Timesheet Details TSR01'[Cost]="Direct Cost"))

ShareHours = CALCULATE(SUM('Timesheet Details TSR01'[Hours]),FILTER('Timesheet Details TSR01','Timesheet Details TSR01'[Cost]="Share Cost"))

 

Percentage = DIVIDE([DirectHours],[ShareHours],2)

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Are you writing measures??

  • manoplaeli's avatar
    manoplaeli
    Icon for Helper II rankHelper II
    9 years ago

    Yes I wrote in meansure

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      9 years ago

      Hi manoplaeli

       

      I think I misunderstood your problem initially.

       

      I have partially used Query Editor to get the correct results.

       

      I have pivoted the hours column to get the correct data structure in order to solve this problem. There are other solutions as well but I find this convenient.

      Pivot

      Then I have created 3 calculated columns to get the Share and Direct % as shown below.

      Results of the pivot columnSHARE%

       

       

      • manoplaeli's avatar
        manoplaeli
        Icon for Helper II rankHelper II
        9 years ago

         

        Hi BhaveshPatel

         

        Thank you very much I got it works now,

         

        Best,