Forum Discussion

Batfab's avatar
Batfab
New Member
5 months ago
Solved

create a report with calender

hi, I would like to import an Excel list with names in rows and events in columns. I may have the same name appear in multiple rows—for example, an absence from January 2 to January 5 in one row, a...
Tips and Tricks
  • Sergii24's avatar
    Sergii24
    5 months ago

    H Batfab, here it is. Make sure to prepare your data in the same format where you have all dates you need repeated for each employee and absence tracked in a separate column. Then use matrix to create an Excel similar PivotTable. Good luck with your project!

Sergii24's avatar
Sergii24
Super User
5 months ago

H Batfab, here it is. Make sure to prepare your data in the same format where you have all dates you need repeated for each employee and absence tracked in a separate column. Then use matrix to create an Excel similar PivotTable. Good luck with your project!