Create a Pivot Table with 2 Fact Tables with Count # and Sum $ as row labels

[mdrew9]

I have 2 fact tables coming from an Oracle DB. I have calculated the status of days overdue that I am going to display as column labels. I have calculated measures for count and sum of each table, when I put these in the value area and put the status as column labels I get the name of all of my measures as row labels, when essentially what I want is # and $ for row labels. The only way I can think of doing this is in the sql of each of my fact tables to create a union between 2 idential queries where the top query adds a UOM with value of # for all rows and the bottom query has the same UOM but $ for all rows. I could write the sql to sum and count these for me but I am looking for more flexibility. Can anyone think of another way???

 

[mdrew9]

No ideas?

 

[barnettjacob]

I think the lack of responses is likely due to the fact that your problem isn't clear!

If what you are trying to do is put both fact tables into 1 pivot that is segmented by status then the answer is a small 'status table' that is related to both fact tables. This way you can use the the status from the table in your column headings and write a measure than sums and counts both fact tables.

If the data in the 2 fact tables is 'identical' then I don't see why you wouldn't 'union' them together to create a single table?

Not sure if this is helpful at all? If you have a fuller explanation of the problem or a sample workbook you can share then I'd be happy to look.

Jacob