Hi every one,
I want a report to be generated in this specific format.
1) I have 4 or 5 columns like country, region, city, product etc.,
2) I have a figure which contains 6*6 squares in which some squares contains numbers in it and these boxes are coloured.
when i click on any number (Or any specific colour) from these squares, its related data from table should be grouped and get me the result.
(ONE SCENARIO: when I click on number 16 from these square boxes, it should gather the data linked to 16 and get the result.)
Can any one tell me how to give relationship for this squares and my data and everything. Help me with this scenario..........
HINT:
you can go through the picture for any clarifications.
from pic, when I click on blue colour, the data should be fetched and should give me the output(suppose I gave some criteria based on country or product.)
similarly when I click on number 12 box, I should get data based on that number.
this is a HEAT MAP
sorry I forgot to put the eg file.