Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cross tab for a certain period of time.

Status
Not open for further replies.

jschill2628

Programmer
Nov 3, 2009
156
US
I have a cross tab without a time range, by severity, entity and by claim count. What I want to do is only show those Claims that fit the following criteria:
({CHICLAIM.REPORT_DT} in DateTime (2013, 07, 01, 00, 00, 00) to {@Run Date})
@RunDate= previous month
If ({CHICLAIM.SPECIAL9}) = "04" then "Severe Harm"
if ({CHICLAIM.SPECIAL9}) = "05" then "Death"

So I only want to see the Severe Harm and Death for FY14. However I also want to show those Entities that do not have claims that are Severe Harm or Death.
Is there any way to do this? If there is, is there also a way to show that an entity without Severe Harm or Death that the claim count is equal to zero?

Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top