Pivot tabe
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
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
Last Comment
Rob Henson
Sounds possible. Can you upload some sample data?
ASKER
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry misunderstood layout of data, as Shums says, don't think its possible with Pivot Table.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
