Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Current report:
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?
check this and let me know
See the attached file, I did some formatting with the dimension background color and text color.
See attached.
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?