Crosstab show the same static data on every group ?
<p>Hi all ,</p>
<p> </p>
<p>I have a crosstable ~</p>
<p> </p>
<p><u><strong>Base data</strong></u> --> Static Data.JPG</p>
<p>3M<br>
9M<br>
1Y<br>
2Y<br>
3Y<br>
4Y<br>
5Y<br>
7Y<br>
10Y</p>
<p> </p>
<p> </p>
<p><strong><u>Result </u></strong> --> Report Result.JPG </p>
<p> </p>
<p>Sales A Risk<br>
</p>
<p>3M 15<br>
9M 10<br>
1Y 12<br>
2Y 10<br>
3Y 13<br>
4Y 10<br>
5Y 14<br>
7Y 10<br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales B Risk<br>
</p>
<p>3M -5</p>
<p>9M 10<br>
1Y 12<br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales C Risk<br>
</p>
<p>5Y 66</p>
<p>10Y -1254</p>
<p> </p>
<p> </p>
<p>Because Sales B Data only have 3M,9M,1Y,10Y </p>
<p> Sales C Data only have 5Y,10Y</p>
<p> </p>
<p>How can i show the same static data on every group ?</p>
<p> </p>
<p>like this</p>
<p> </p>
<p>Sales B Risk<br>
</p>
<p>3M -5</p>
<p>9M 10<br><span style="color:#ff0000;">1Y 0</span></p>
<p><span style="color:#ff0000;">2Y 0<br>
3Y 0</span></p>
<p><span style="color:#ff0000;">4Y 0<br>
5Y 0<br>
7Y 0</span><br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales C Risk<br>
</p>
<p><span style="color:#ff0000;">3M 0</span></p>
<p><span style="color:#ff0000;">9M 0<br>
1Y 0</span></p>
<p><span style="color:#ff0000;">2Y 0<br>
3Y 0</span></p>
<p><span style="color:#ff0000;">4Y 0</span></p>
<p>5Y 66</p>
<p><span style="color:#ff0000;">7Y 0</span></p>
<p>10Y -1254</p>
<p> </p>
<p> </p>
<p>Thanks ~~~</p>
<p> </p>
<p> </p>
<p> </p>
<p>I have a crosstable ~</p>
<p> </p>
<p><u><strong>Base data</strong></u> --> Static Data.JPG</p>
<p>3M<br>
9M<br>
1Y<br>
2Y<br>
3Y<br>
4Y<br>
5Y<br>
7Y<br>
10Y</p>
<p> </p>
<p> </p>
<p><strong><u>Result </u></strong> --> Report Result.JPG </p>
<p> </p>
<p>Sales A Risk<br>
</p>
<p>3M 15<br>
9M 10<br>
1Y 12<br>
2Y 10<br>
3Y 13<br>
4Y 10<br>
5Y 14<br>
7Y 10<br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales B Risk<br>
</p>
<p>3M -5</p>
<p>9M 10<br>
1Y 12<br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales C Risk<br>
</p>
<p>5Y 66</p>
<p>10Y -1254</p>
<p> </p>
<p> </p>
<p>Because Sales B Data only have 3M,9M,1Y,10Y </p>
<p> Sales C Data only have 5Y,10Y</p>
<p> </p>
<p>How can i show the same static data on every group ?</p>
<p> </p>
<p>like this</p>
<p> </p>
<p>Sales B Risk<br>
</p>
<p>3M -5</p>
<p>9M 10<br><span style="color:#ff0000;">1Y 0</span></p>
<p><span style="color:#ff0000;">2Y 0<br>
3Y 0</span></p>
<p><span style="color:#ff0000;">4Y 0<br>
5Y 0<br>
7Y 0</span><br>
10Y 15</p>
<p> </p>
<p> </p>
<p>Sales C Risk<br>
</p>
<p><span style="color:#ff0000;">3M 0</span></p>
<p><span style="color:#ff0000;">9M 0<br>
1Y 0</span></p>
<p><span style="color:#ff0000;">2Y 0<br>
3Y 0</span></p>
<p><span style="color:#ff0000;">4Y 0</span></p>
<p>5Y 66</p>
<p><span style="color:#ff0000;">7Y 0</span></p>
<p>10Y -1254</p>
<p> </p>
<p> </p>
<p>Thanks ~~~</p>
<p> </p>
<p> </p>
0
Comments
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management