Forum Discussion
Values to high does to data structure
lbendlin I manage to work out solution.
I dublicated main table and deleted 'Leave Brought Forward', 'Leave Booked' and 'Leave Balance' columns from the original table.
Then on the dublicated I removed all the columns except 'Staff Number','Full Name','Start Date' and 'Leave Brought Forward', 'Leave Booked' and 'Leave Balance'.After that i grouped dublicate table like this.
After that I merged both tables.
And expanded grouped table
That seams to have solved my problem.
There might be different way to do this but its seams to be working without any problems.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
lbendlin I manage to work out solution.
I dublicated main table and deleted 'Leave Brought Forward', 'Leave Booked' and 'Leave Balance' columns from the original table.
Then on the dublicated I removed all the columns except 'Staff Number','Full Name','Start Date' and 'Leave Brought Forward', 'Leave Booked' and 'Leave Balance'.
After that i grouped dublicate table like this.
After that I merged both tables.
And expanded grouped table
That seams to have solved my problem.
There might be different way to do this but its seams to be working without any problems.