Pivot Tables...Help???

rohitpareek · Apr 23rd, 2002, 11:51 PM

Hi!!

How to change the values displayed in Pivot Table's Data portion using a Macro...Can I change the summary options of the data using Macro..?

EHarvey · Apr 24th, 2002, 04:10 AM

Yes

The code i used:

ActiveSheet.PivotTables("insert pivot tablename here").PivotFields("Month").CurrentPage = _Current_Mth

Current_Mth is a variable I use that picks up a month value I put elsewhere in the spreadsheet.

I have only used this for Data fields placed in the "Page" area of table.

Cheers

rohitpareek · Apr 24th, 2002, 04:21 AM

Hi,

Thanks a lot for reply!!

If u have any idea for following..

On the data portion I want to display concatenated string that contains values of text fields from database. It seems that Pivot Table displays only integers on the data portion....

In yet another report,I want to display 'comment' which is a text field of my database,just above the figure in data part.....Is there any way out?

ebranck2 · Jun 10th, 2002, 06:36 AM

Hi There,

I am looking for exactly the same thing. Did you suceed ?

Concatenate Text string in a pivot table.

E

rohitpareek · Jun 10th, 2002, 06:42 AM

hi!!

i've included that string in the row portion of the pivot table and it acts as a sub-group....there is no way...i could find by which I can include text in data portion..

Also Please let me know If I can add Mean/Median and Other such Summary cols in place of or addition to the row totals.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:51 PM	#1
rohitpareek New Member Join Date: Apr 2002 Location: New Delhi,India Posts: 4	Hi!! How to change the values displayed in Pivot Table's Data portion using a Macro...Can I change the summary options of the data using Macro..?

Apr 24th, 2002, 04:10 AM	#2
EHarvey New Member Join Date: Apr 2002 Posts: 6	Yes The code i used: ActiveSheet.PivotTables("insert pivot tablename here").PivotFields("Month").CurrentPage = _Current_Mth Current_Mth is a variable I use that picks up a month value I put elsewhere in the spreadsheet. I have only used this for Data fields placed in the "Page" area of table. Cheers

Apr 24th, 2002, 04:21 AM	#3
rohitpareek New Member Join Date: Apr 2002 Location: New Delhi,India Posts: 4	Hi, Thanks a lot for reply!! If u have any idea for following.. On the data portion I want to display concatenated string that contains values of text fields from database. It seems that Pivot Table displays only integers on the data portion.... In yet another report,I want to display 'comment' which is a text field of my database,just above the figure in data part.....Is there any way out?

Jun 10th, 2002, 06:36 AM	#4
ebranck2 New Member Join Date: Jun 2002 Posts: 4	Hi There, I am looking for exactly the same thing. Did you suceed ? Concatenate Text string in a pivot table. E

Jun 10th, 2002, 06:42 AM	#5
rohitpareek New Member Join Date: Apr 2002 Location: New Delhi,India Posts: 4	hi!! i've included that string in the row portion of the pivot table and it acts as a sub-group....there is no way...i could find by which I can include text in data portion.. Also Please let me know If I can add Mean/Median and Other such Summary cols in place of or addition to the row totals.