Forum Discussion

ek2112's avatar
ek2112
Icon for Advocate II rankAdvocate II
7 years ago
Solved

Uniform salary calculation

Hi all,   I have a salary table with employee salary for each month. I also have a table that pulls in timesheet info for each employee on a daily basis.    I am trying to summarize by employee, ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.  Extend your Month Table to March to get that month's data in the matrix.

     

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    You are welcome.  Done - see this file.

  • ek2112's avatar
    ek2112
    7 years ago

    Ashish_Mathur neat! The sorting is by MonthIndex. Thank you again.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Yes.  You are welcome.

ek2112's avatar
ek2112
Icon for Advocate II rankAdvocate II
7 years ago

Ashish_Mathur neat! The sorting is by MonthIndex. Thank you again.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Yes.  You are welcome.