In this attached excel in column F and G is actually mu result set which i have manged to manully enter. I need to get this result by applying pivot.
My need is for ex in coloum C type i have Veg,Veg/Fruit etc. So now i need to filter and say tomoto shuld come in as fruit and also under the type fruit as well. can som one help me?
Bookmarks