dynamic report in columns

Have 2 check box filtters (this checkbox created left side and right is one table)

checkboxfilter1

AMERICA
INDIA

SOUTHAFRICA

checkboxfilter2

country

state

sales

balce

now when select checkbox 'sales' this field add in table  like wise mean checkbox should be columns

and check box ahould be rows

example

output like

from check i am select checkboX(Country ,state and sales now) and checkbox1 i am selected india

o/p: Country  state    sales

       india       Delhi     10K

      india   maharastra 20k

    india     chennai     30k

now i am select from checkbox2 is balance

o/p: Country  state    sales   balace

       india       Delhi     10K  2

      india   maharastra 20k  5

    india     chennai     30k  7

like that i need dynamic reports.

thanks

shanvitha