Current Month

[NavinReddy]

Dear All,

I have 12 Months in my database

But only i have 4 months data

Month  Dollars

jan          100

feb          300

mar         400

apr          700

may          -

june          -

july           -

aug           -

sep           -

oct           -

nov          -

dec          -

like this format i have data

in this data current month if i search Apr i want to show ,

and every month comparision also i can show

how can i solve this issue

please help some one

Thanks in Advance

Niranjan

[NavinReddy]

sorry pivot table i  want to show comparisons

[Anonymous]

Please make a mock up drawing of the result you are expecting.