Caravishah
New Member
Hi,
Simply put my question is how do we get rid of the "sum of"/"count of" etc. that comes along when we run pivot on a data table? this might be simple but i tried googling around but didn't find a solution.
I want to vlookup on a pivot table (date as column) but the issue is pivot has "sum of (month) Jan-14" and my table directly has the month i.e Jan-14 in date format.
The helper cell using right to extract Jan-14 doesn't help because the extracted Jan-14 is not in date format.
Any thoughts/ideas? Thanks.
Simply put my question is how do we get rid of the "sum of"/"count of" etc. that comes along when we run pivot on a data table? this might be simple but i tried googling around but didn't find a solution.
I want to vlookup on a pivot table (date as column) but the issue is pivot has "sum of (month) Jan-14" and my table directly has the month i.e Jan-14 in date format.
The helper cell using right to extract Jan-14 doesn't help because the extracted Jan-14 is not in date format.
Any thoughts/ideas? Thanks.