Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickC
Yak Posting Veteran
68 Posts |
 Posted - 2012-01-09 : 04:42:05
|
| HelloDoes anyone have a guide on how to write a triangulation report for insurance - I'm getting worried as can't find any information and still having problems with the dates.My report works fine in the sense when theres date it shows a value but I need it to show the same values in quarters where there were no premiumsWhat I mean isbasically report looks similar to this AY Qtr Premium Running Total 2007 Q1 2000 20002007 Q2 1000 30002007 Q3 4000 70002008 Q2 1000 8000What I need it to look like (and 2007 Q4, and 2008 Q1 dont exist anywhere :( ) AY Qtr Premium Running Total 2007 Q1 2000 20002007 Q2 1000 30002007 Q3 4000 70002007 Q4 0 70002008 Q1 0 70002008 Q2 1000 8000Really struggling to find out any information, and worried I'm not going to be able to complete this now :/ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Help for Triangulation Report