Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with pivot table formating
Hi ti all:
I got a pivot table getting data from an odbc SQL server. The first column is agent ID, the second one is supervisor, the third is agent name and the fourth one is the call volume. Here is an example: AgentID Name Supervisor Call volume 01 Nick Super1 10 Nick Super1 4 02 John Super1 5 03 Marie Super2 8 If I do a Vlookup for agentID 01, I'll get call volume of 10 but in fact it's 14 since Nick got 10+4. I can't combine a sum with vlookup with the name since Nick is not the only name showing in the pilot table. I need to find a way of calculating call volume of agentid 01 untill I get a different agentid in a vlookup. Thanks a bunch! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with pivot table formating
On 25 mai, 12:49, magickarle wrote:
Hi ti all: I got a pivot table getting data from an odbc SQL server. The first column is agent ID, the second one is supervisor, the third is agent name and the fourth one is the call volume. Here is an example: AgentID Name Supervisor Call volume 01 Nick Super1 10 Nick Super1 4 02 John Super1 5 03 Marie Super2 8 If I do a Vlookup for agentID 01, I'll get call volume of 10 but in fact it's 14 since Nick got 10+4. I can't combine a sum with vlookup with the name since Nick is not the only name showing in the pilot table. I need to find a way of calculating call volume of agentid 01 untill I get a different agentid in a vlookup. Thanks a bunch! Here the macro I created. it's seems to work. if anynone want to tweek it so it's more efficient, you're welcome Sub copydate() Row = Row + 1 totalrows = ActiveSheet.UsedRange.Rows.Count daterow = daterow + 1 agentrow = agentrow + 1 For Row = Row To totalrows If Cells(Row, 3) = 0 Then daterow = Cells(Row - 1, 3) ' Cells(Row, 2).Value = daterow Cells(Row, 3).Value = daterow End If Next Row End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
pivot table formating | Excel Discussion (Misc queries) | |||
chart formating disappears when i refresh pivot table data | Excel Discussion (Misc queries) | |||
how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions |