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

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,