Crosstab show the same static data on every group ?

NOSTALGY
edited February 11, 2022 in Analytics #1
<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>

Comments

  • <p>Hi,</p>
    <p> </p>
    <p>can you upload your design with a flat file for the data ?</p>
    Warning No formatter is installed for the format ipb
  • <p>Hi,</p>
    <p> </p>
    <p>In the CrossTab Property Editor, go to Empty/Row Columns and check Show Empty Rows, as shown in the attached screenshot.</p>
    <p> </p>
    <p>Regards,</p>
    <p> </p>
    <p>P.</p>
    <p>
    Warning No formatter is installed for the format ipb
  • <p><span>Thank you for your help.</span></p>
    <p> </p>
    <p><span style="color:#000000;"><span>It's useful for me.</span></span></p>
    <p> </p>
    <p><span style="color:#000000;"><span> :)  :)  :) </span></span></p>