momcaro
Member
I am using Excel 2013. I have done some research on consolidating tables in a pivot, but I don't think it applies to what I'm trying to accomplish (no relations between my tables).
I have 3 different tables of issues/tickets coming from 3 different sources. There are a couple of common fields I would like to run a pivot on (such as open date, priority).
I do not want to consolidate the data into one table.
Is there a way to have a pivot to count tickets for all 3 tables by open date and priority? (I can manually count using formulas, but was wondering if pivot was an option)
Thank you,
Caroline
I have 3 different tables of issues/tickets coming from 3 different sources. There are a couple of common fields I would like to run a pivot on (such as open date, priority).
I do not want to consolidate the data into one table.
Is there a way to have a pivot to count tickets for all 3 tables by open date and priority? (I can manually count using formulas, but was wondering if pivot was an option)
Thank you,
Caroline