Jazzing up a pivot table

[Daniel_Moore]

Trying to make a QVW that looks like this report. I've made a pivot table - see attached QVW but it's a bit lacking... Any suggestions?

Current report:

[Anonymous]

check this and let me know

[#3]

See the attached file, I did some formatting with the dimension background color and text color.

[#4]

See attached.

[Daniel_Moore · Accepted solution]

Thanks for the ideas everybody! After some thought I decided to 'pivot' my question. What a pun- cause a straight table looks more like the original report:

I added some if statements in the load script to make the pivots & subtotals work:

     if(left(Status,3)='Ope',if(left(Severity,1) ='H',1,0),0) as OpenH,

     if(left(Status,3)='Ope',if(left(Severity,1) ='H',0,1),0) as OpenL,

     if(left(Status,3)='Ope',1,0) as Open,

etc.

I think that's closer to the original report. Agreed?