Django for Data Tables to group by when coloumn hidden

Sidpeesar

Question: I have a Data table displaying on django , but now I like to group by when ever I will hide the column.

column1 column2 column3

AAA CAD 25

AAA USD 12

BBB CAD 13

BBB USD 16

CCC CAD 11

CCC USD 18

The above table will be displayed on web page using Django, now when ever I hide column2 It should group by and display like below table.

column1 column3

AAA 37

BBB 29

CCC 39

when ever I un-hide it again it should display same as first table again.

can anyone tell me the code how to do it .

Thanks in advance.