Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Pivot Tables...Help???

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    New Delhi,India
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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..?

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    New Delhi,India
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi There,


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

    Concatenate Text string in a pivot table.

    E

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    New Delhi,India
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •