+ Reply to Thread
Results 1 to 2 of 2

VBA newbie - help with pivot table

  1. #1
    Forum Contributor
    Join Date
    03-11-2005
    Posts
    115

    VBA newbie - help with pivot table

    Hi all,

    I have a pivot-table that calculates from a worksheet called "data" range:A1:E54710.

    The left-hand side of the pivot is the contents of column C.
    The pivot table calculates the following: count of column D, sum of column E, sum of column F, and sum of column G.


    At the moment, the pivot-table has the 4 data items listed vertically for each item. Ideally I would like to report on them horizontally, which would make it much easier to view.

    Any ideas on a function or VBA that would help me.

    Thanks

    Amy xx

  2. #2
    Forum Contributor
    Join Date
    03-11-2005
    Posts
    115

    NEWBIE - problem with duplication in pivottable

    Hi everyone, I haved sorted that problem by moving the data field to the horizontal position, now the 4 items are listed horizontally.

    I have another problem. Column C (the count field) includes duplicate dates but with a different variable in column A.
    Therefore when I do a count, I am double counting those dates with more than one entry.

    Is there a way to include only the distinct dates (exluding the duplicate rows in the count).
    I still need to be able to sum all the rows for the other 3 variables.

    VBA or functions ?

    Thanks for your thoughts....

    Amy x

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1