Pivot Tables...Help???

rohitpareek

New Member
Joined
Apr 22, 2002
Messages
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..?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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
 
Upvote 0
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?
 
Upvote 0
Hi There,


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

Concatenate Text string in a pivot table.

E
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,537
Messages
6,114,216
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top