Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Re-use cross tabs data in sub-report
Migrateduser
<p>I am trying to implement a report that has a crossTab. And on the crossTab I have calculated the GrandTotal of savings per quarter.</p>
<p> </p>
<p><span style="color:#000000;"> Time Period</span></p>
<p>FY15Q1</p>
<p style="text-align:center;">FY15Q2</p>
<p> Product</p>
<p style="text-align:right;">Cost</p>
<p style="text-align:right;"><span style="color:#000000;">Saving</span></p>
<p><span style="color:#000000;">Cost</span></p>
<p><span style="color:#000000;">Saving</span></p>
<p><span style="color:#000000;">Abc</span></p>
<p style="text-align:right;">10</p>
<p style="text-align:right;"><span style="color:#000000;">2</span></p>
<p><span style="color:#000000;">25</span></p>
<p><span style="color:#000000;">5</span></p>
xyz
20
3
23
5
Grand Total of Savings by Quarter
5
10
<p> </p>
<p>Now I need to add one more sub report which can use the Grand Total's from above crossTab</p>
<p> </p>
<p> </p>
<p><strong><span style="color:#000000;">Saving</span></strong></p>
<p style="text-align:center;"><strong><span style="color:#000000;">Cumulative</span></strong></p>
<p> FY15Q1</p>
<p style="text-align:right;"><span style="color:#000000;">10</span></p>
<p><span style="color:#000000;">10</span></p>
<p>FY15Q2</p>
<p style="text-align:right;"><span style="color:#000000;">13</span></p>
<p><span style="color:#000000;">23</span></p>
<p>FY15Q3</p>
<p style="text-align:right;"><span style="color:#000000;">15</span></p>
<p><span style="color:#000000;">38</span></p>
<p> </p>
<p>Is it possible to achive this?</p>
Find more posts tagged with
Comments
There are no comments yet