Using Excel 2010 Pivot table, I am trying to do the following
Column 1, displays all the sources...a,b,c,d,e,f.....
Column 2 is a Total count for each source a,,c,d,e,f
I have another field Status (status a, b, c, d, e, f)
I want to add a column for each source above that totals how many of status D only.
Let me know if this is possible or if I should do this another way
Column 1, displays all the sources...a,b,c,d,e,f.....
Column 2 is a Total count for each source a,,c,d,e,f
I have another field Status (status a, b, c, d, e, f)
I want to add a column for each source above that totals how many of status D only.
Let me know if this is possible or if I should do this another way