Pivoting by Date

benjamin · January 27, 2011 4:53AM

Hi

I would like to pivot by StatementDate and another field in omniscope.Currently StatementDate does not appear in the piviot list since it is a date/time . (I.e i would like a table with Statemdate as column headers and a category split as rows E.g The number of people by Martial Status split by StatementDate ) If i convert this to category then this alters all other time/series graphs i have in omniscope.Also the ordering is not in the natural time series manner when converting to category.With lots of StatementDate it is inconceiveable for me to order this manually or link to a ordering source.I have thought about aggrregating in table view however i would have to create a seperate field for each of the second pivot item which waste space.

1.Can pivot tables allow pivoting with StatementDates . (and other number categories such as intergers)
2.Can a column have a differenrt data type for just one tab.

Any help would be much appreciated.

tjbate · January 27, 2011 5:25AM

Benjamin - this is an example where duplicating a column and data typing it two different ways can increase the options for visualisation. If you re-format your Date/Time field so that the literal text values will sort naturally when changed to Categories, yyyy-MM-dd and then duplicate the Statement Date field and type the duplicate field as Category, you should not have to do a manual re-order of the Category value sort order. Duplication and changing the data type allows you to use Date/Time typing where appropriate, and still use the Category version of the field in the Pivot View and other Category-only views.

Welcome!

Categories

Ideas Parade