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.
lbendlin That is only if we look at 'Leave Brought Forward' column.
'Leave Booked' and 'Leave Balance' still has that problem and across all employees.
I dont use 'Leave Brought Forward' in my matrix tables.
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.