We help IT Professionals succeed at work.

Pivot tabe

89 Views
Last Modified: 2017-03-30
Dear experts,

I have dates on A1 to A10, B1 to B10, C1 to C10.
Each with a respective header (Calls, Meetings, Contracts) in row 1 for each column.


I want to do a pivot table which:
on the left side indicate in three rows the labe of Calls, Meetings, and Contracts.
on the top it lists week 1 to 52 of this year.
in the date portion it indicate how many dates occur under which week # for each row i.e. Calls, Meetings, Contracts.

Br,
JP
Comment
Watch Question

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Sounds possible. Can you upload some sample data?

Author

Commented:
Hi Rob,
Yes.
Please see uploaded file.
Thanks!
JP
Book1.xlsx
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Sorry misunderstood layout of data, as Shums says, don't think its possible with Pivot Table.