group count SubTotal Desired_Field
WEEK1 9 36 36
WEEK2 1 36 27
WEEK3 3 36 26
WEEK4 7 36 23
WEEK5 2 36 16
WEEK6 1 36 14
WEEK7 2 36 13
WEEK8 3 36 11
WEEK9 2 36 8
WEEK10 1 36 6
WEEK11 1 36 5
WEEK12 4 36 1
I have Group, count and SubTotal with me. I want to get the values as shown in Desired_Field? Please help with the query. Thanks
