Hi Everyone,
How we can bifurcate the data based on the date.
e.g i want to calculate the sum(amount) and count of numbers based on the date like up to the march and after the march.
Please find the attached spread sheet for reference.
It will be very great full if gives the solution as selection based.That means if am selecting any year it has to show the data upto march and after march and if i am not selecting it has to show current year data upto march and after the march.
Thnx in adv,
Ajay
