Question: I have data in Excel that is laid out in the following form:

Field 1: Date

Field 2: Gender

Field 3: (Sales in) 2007

Field 4: (Sales in) 2008

How do I import this data into Prism so I get 2007 and 2008 as members I can place on a drop-down list.

Answer: Prism needs data in a flat format, such as:

Field 1: Date

Field 2: Gender

Field 3: Year

Field 4: Sales

To automatically generate this data from the pivot-like data, check out the following blog post.