Hi Punnam,
Solution provided by Mr. Srinivasa Murthy is OK.
Actually in my 1st post I made a pivot of raw data. In the recent post, I gave only raw data to see if the formula is possible without making it pivot (which will consume 60 columns for the month data (Qty. and Weight together). I prefer to reduce the same.
Moreover in your earlier post, you changed to Grapes (where I need sum of Black Grapes and Green Grapes together.
If you can help me on my recent post (#4), I will be grateful to you.
Thanks,
Nagesh.
Bookmarks