+ Reply to Thread
Results 1 to 2 of 2

Text and Numerical data in a Pivottable without summarising?

  1. #1
    Registered User
    Join Date
    05-24-2006
    Posts
    1

    Text and Numerical data in a Pivottable without summarising?

    I have a database of mixed text and data, index by common dates which I need to present as a single table, sorted by date;

    Ie,

    date1, StartTime, textValue
    Date1, Runtime, NumberValue
    Date2, StartTime, textValue
    Date2, Runtime, NumberValue

    becomes

    ------- StartTime ---- Runtime
    Date1 textValue NumberValue
    Date2 textvalue NumberValue

    In principle this should be possible using a pivottable but that will only summarise the data, in terms of Count, Sum, etc, which won't handle the Textvalues at all.

    Is it possible to just present the data 'As Is' rather than summarising it and handling everying as though it were a number?

    Thanks

  2. #2
    Miguel Zapico
    Guest

    RE: Text and Numerical data in a Pivottable without summarising?

    You can create the layout you want on pages, rows and columns, and then use a
    "dummy" measure for the data area (like the count of textValue, for example).
    By dummy I mean that it won't be useful for you (you can even hide the
    column), but you will have all the other columns with the layout you want.

    Hope this helps,
    Miguel.

    "Madhouse" wrote:

    >
    > I have a database of mixed text and data, index by common dates which I
    > need to present as a single table, sorted by date;
    >
    > Ie,
    >
    > date1, StartTime, textValue
    > Date1, Runtime, NumberValue
    > Date2, StartTime, textValue
    > Date2, Runtime, NumberValue
    >
    > becomes
    >
    > ------- StartTime ---- Runtime
    > Date1 textValue NumberValue
    > Date2 textvalue NumberValue
    >
    > In principle this should be possible using a pivottable but that will
    > only summarise the data, in terms of Count, Sum, etc, which won't
    > handle the Textvalues at all.
    >
    > Is it possible to just present the data 'As Is' rather than summarising
    > it and handling everying as though it were a number?
    >
    > Thanks
    >
    >
    > --
    > Madhouse
    > ------------------------------------------------------------------------
    > Madhouse's Profile: http://www.excelforum.com/member.php...o&userid=34742
    > View this thread: http://www.excelforum.com/showthread...hreadid=545029
    >
    >


+ 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