For context we collect data on behalf of a client that needs differing percentage splits applied to different data categories. This is used to account for waste data at colleges in the UK, showing data generated in residential parts of the college vs non residential.
Is there a way I can create a table that shows total waste weight for each college and allows the client to apply both a residential and non-residential percentage to it?
Darwin College Total 100 tonnes
Non res (60%) 60 tonnes
Res (40%) 40 tonnes
Keynes College Total 50 tonnes
Non res (50%) 25 tonnes
Res (50%) 25 tonnes
I'd like the client to be able to tweak the percentage split each year to represent how the college building was used in that year within their dashboard.