Pivot table showing expressions row by row instead of column by column

[#1]

1. I want to create a table based in calculations as in the example below.

report for client cli1:	23/09/2013	18/09/2013
Mylabel1:	0.40=OK/ RECORDS COUNT=2/5	0.25 =OK/ RECORDS COUNT=1/4
Mylabel2:	20=METRICS_COUNT * RECORDS_COUNT	16=METRICS_COUNT * RECORDS_COUNT
Mylabel3:	5= Records Count	4 = Records Count

2. Notice that I’ll have a listbox with the client name, and the results table should show up when I click on the client name.

3. Also this as to be discriminated by dates as columns, so the number of columns is not fixed.

Source:

RUN_ID	EXECUTION_DATE	CLIENT	METRICS_COUNT	RECORDS_COUNT	OK
1	18/09/2013 12:00	cli1	4	4	1
1	18/09/2013 12:00	cli2	4	4	1
2	23/09/2013 12:00	cli1	4	5	2
2	23/09/2013 12:00	cli2	4	3	0

This can be done using a Pivot table and using CLIENT and EXECUTION_DATE as dimensions. But I'll have Mylabel2 and Mylabel3 to the right of Mylabel1, instead on the next row.

So how to put these labels on next rows?

[yduval75]

Hello,

If you use a straight table instead of a pivot table with dates as dimension and label 1, label 2 and label 3 as expressions.
Then in properties / Presentation, you click on Horizontal.

that' s solve your problem ?

Best regards

Yoann DUVAL

[#3]

Almost!

Your solution creates all the rows I need and the first column (first date).

I'm missing how to create the following date columns with your solution.

[yduval75]

But if you put Dates in dimensions, you should have all the dates in your columns
Can you send your qvw file ?

[#5]

Yes that should work. After I try it I'll let you know.

Thanks,

Miguel.

[#6 · Accepted solution]

Use a straight table instead of a pivot table with dates as dimension AND GROUP BY EXECUTION_DATE and label 1, label 2 and label 3 as expressions.

Then in properties / Presentation, you click on Horizontal.