I have a query that has the following structure:
Date Dim01 Dim02 Dim03 Dim04
12/31/14 0.123 1.234 0.567 2.987
01/05/15 0.126 1.287 0.611 2.888
Is it possible to make a crosstab query (or any type) to get an output like this?
Date Dim Value
12/31/14 Dim01 0.123
12/31/14 Dim02 1.234
12/31/14 Dim03 0.567
12/31/14 Dim04 2.987
01/05/15 Dim01 0.126
01/05/15 Dim02 1.287
01/05/15 Dim03 0.611
01/05/15 Dim04 2.888
The ultimate goal is to produce a report and graph that will show the variation for an individual Dimension over time.
Any and all help and suggestions are appreciated. Thanks for your time and have a great new year!