Hi,
I have a crosstab.
I have columns as Month -> Buy/Sell Type (column grouping)
I have rows as Region -> Material -> (row grouping)
sales in volume as the fact cell
I have two system one is SAP and another is SQL Server. we call it as Source. The data for comes from SQL Server for last two months and for earlier months comes from SAP.
Customer asking like the volume that comes from SQL Server should be highlighted.
If I add source in the columns at 3rd level... two columns coming for SAP & SQL Server.
If I add source in the rows at 3rd level... two rows coming for SAP & SQL Server.
But I want all of them in a single row. How could I solve it?
the looks like the below__
Sep2010 oct2010 Nov2010 Dec2010
buy buy buy buy
westregion Television [source hided] 550 300
200 100
eastregion Television [source hided] 10 20 30 40
the row one only getting prb. because there we have two systems. But I want all the data into single row
plz help me.
Please help me on the above issue.
If I keep source field in Columns then two columns appearing.
Sep2010 oct2010 Nov2010 Dec2010
buy buy buy buy
SAP Sql Server SAP Sql Server SAP Sql Server SAP Sql Server
westregion Television 550 300 200 100
eastregion Television 10 20 30 40