Export and Create PivotTable in Excel
Amber Schmitz
|
57 steps
|
4 minutes
1
Login to Kofax
2
Click here:
3
Click here:
4
Click here:
5
Click here:
6
Click "Kofax AP Essentials Analytics"
7
Click "OK"
8
Click here:
9
Click "MX BU"
10
Click "US BU"
11
Click "OK"
12
Click "Documents"
13
Click "Kofax AP Essentials Analytics"
14
Click "Formatted Excel file"
15
Click "Export to Excel OK"
16
Click "Export to Excel OK"
17
Click "1 download in progress"
18
Click "Recent download history"
19
Click "Enable Editing"
20
Click here:
21
Click "U7"
22
Click "Insert"
23
Click "PivotTable"
24
Click "OK"
25
Click "REJECT CODE"
26
Click "TRACK ID"
27
Click "TRACK ID"
28
Click "HELD BY"
29
Click "HELD BY"
30
Click "SUPPLIER NUMBER"
31
Click "HELD BY"
32
Click "HELD BY"
33
Click "REJECTED BY"
34
Press [[alt]] + [[tab]]
35
Press [[alt]] + [[tab]]
36
Press [[alt]] + [[tab]]
37
Press [[alt]] + [[tab]]
38
Press [[alt]] + [[tab]]
39
Press [[alt]] + [[tab]]
40
Click here:
41
Click "Excel - 17 running windows"
42
Click "Documents (63).xlsx - Excel"
43
Click "FOR ACTION"
44
Click "BY REJECT CODE"
45
Press [[alt]] + [[tab]]
46
Press [[alt]] + [[tab]]
47
Press [[alt]] + [[tab]]
48
Click "Design"
49
Click "Report Layout"
50
Click "Subtotals"
51
Click "Report Layout"
52
Click "Show in Tabular Form"
53
Click "REJECTED BY"
54
Click "B"
55
Click "C"
56
Click "Design"
57
Click "A1"
