I would like to display values as % of total.
Example I have head count by batch. instead of showing actual number of students in each batch, I want to show it as % of total per batch.
Batch 1 20%
Batch 2 40%
Batch 3 10%
Batch 4 30%.
My table looks like
Student ID, Batch ID, Fees
1,Batch1,5000
2,Batch1,5000
3,Batch2,3000
4,Batch4,2000
5,Batch3,7000