Crosstab showing data value in row heading

[Phil Scottow]

I have a simple calendar table in FM. to this I have added some extra rows. example ,to_number ('95') as Marker1
,to_number ('100') as Marker2. All 'Data usage' Properties are set to Attribute. This seems to be fine ( test sample in FM returns full date column followed by Marker1 and Marker2 columns).

Date              Marker1   Marker2
01/01/2013       95            100
02/01/2013       95            100
etc.

But when I create a crosstab with the date as the columns and the markers as the rows I get the date correctly but the values of the Markers as the row values
What I Get
                01/01/2013    02/01/2013
95
100
95
100

What I expected
                01/01/2013    02/01/2013
Marker1          95                95
Marker2         100               100


what am I doing wrong
Thanks in advance

[MFGF]

Hi Phil,

When you create a crosstab, you are delivering the member captions on the edges as your row and column titles, and you are displaying measure values in the crosstab cells. If this were not the case, you would get column headings of 'Date' in your example rather than seeing the date captions.

Why not deliver your data as a List instead of a crosstab? This is effectively what you are doing when you test in Framework Manager.

Cheers!

MF.

[Phil Scottow]

Thanks MF. unfortunatly I require the data in a crosstab so I can build a graph from it. I can generate a list without any problems.

[MFGF]

In that case you will need your 95 and 100 values as measures, set to aggregate with a Max behaviour, and you will need Marker 1 and Marker 2 as row values within a Markers column.

Cheers!

MF.

[Phil Scottow]

Thanks MF.
I have now done that and all seems to now work.
Recap for others: Data from FM brought to QS as Attribute. Crosstab counldn't be created from attribute type data, so data was changed to 'Maximum' on QS property pane (from automatic) and it all started working. ie changing data back to Aggrigate.