Hi All,
I have detailed below the issues I am having with a Pivot table when I try
and use the table as a basis of the raw data to prepare 100 client
statements by clicking in the statement cell inserting = and then picking a
cell in the pivot table; I have described in more detail below.
Thank you,
Mike B
=GETPIVOTDATA("Net Terminal Income",$A$3,"dba","17 North","Reporting_Period
",1,"z_Month","Jan 2015","IGB Number","513140","Manfacturer","IGT","VGT","VGT
01")
Sum of Net Terminal Income
Column Labels
Row Labels
1
2
Grand Total
17 North
106907.87
83926.64
190834.51
Jan 2015
8489.81
15035.61
23525.42
VGT 01
1564.38
3588.77
5153.15
IGT
1564.38
3588.77
5153.15
513140
1564.38
3588.77
5153.15
1721275
1564.38
3588.77
5153.15
VGT 02
766.54
1767.99
2534.53
Speilo
766.54
1767.99
2534.53
516678
766.54
1767.99
2534.53
3300007827
766.54
1767.99
2534.53
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
