M
MTBer
Pivot table has the names Zurich & Zurich Advice Network in the ro
detail, the table is grouped by month and year. Data is returned fo
Zurich but not for Zurich Advice Network.
formula is
GETPIVOTDATA('Comps by Intro'!$A$1,$A122&" "&B$4&" "&B$5)
where a122 is row heading ie Zurich
B4 is year
b5 is month
My theory is the spaces in the title "Zurich Advice Network" are th
trouble, and to work around this I have done a Find Replace all space
with _. In my pivot table and in the output report, so far all i
good.
Am I creating any trouble further down the line by changing the pivo
table descriptions, so far so good. Unfortunately the source dat
cannot be changed as it is a csv file with over 98000 rows.
Any better ideas for extracting the data from the pivot table to
report for further analysis
detail, the table is grouped by month and year. Data is returned fo
Zurich but not for Zurich Advice Network.
formula is
GETPIVOTDATA('Comps by Intro'!$A$1,$A122&" "&B$4&" "&B$5)
where a122 is row heading ie Zurich
B4 is year
b5 is month
My theory is the spaces in the title "Zurich Advice Network" are th
trouble, and to work around this I have done a Find Replace all space
with _. In my pivot table and in the output report, so far all i
good.
Am I creating any trouble further down the line by changing the pivo
table descriptions, so far so good. Unfortunately the source dat
cannot be changed as it is a csv file with over 98000 rows.
Any better ideas for extracting the data from the pivot table to
report for further analysis