Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
add column header in Cross tab
oraBirt
<p>HI, all</p><p>Is there a way to add column header (see the red part below)?</p><p> 1/2014 2/2014 </p><p>[color=#c00000;]<span style="font-size:medium;">SV Emp Type REG OVT TOTAL REG OVT TOTAL Total Reg Total Ovt Total SV[/color]</span></p><p>[color=#000000;]<span style="font-size:medium;"> [/color]</span></p><p>[color=#000000;]<span style="font-size:medium;"> [/color]</span></p><p>[color=#000000;]<span style="font-size:medium;"><span style="font-size:medium;">SV1 empA 3 4 7 5 6 11 8 10 18[/color]</span></span></p><p> </p><p><span style="font-size:medium;">[color=#000000;]<span style="font-size:medium;">SV2 empB 1 2 3 2 3 5 3 5 8[/color]</span></span></p><p><span style="font-size:medium;"><span style="font-size:medium;">Total /Month 4 6 10 7 9 16 </span> DISPLAY empty here?</span></p><p> </p><p>I added a label there, but got repeated repeated column header.</p><p>Also, is possible NOT to display the value for Total reg, total OVT, total SV( right side of the first table's bottom line )?</p><p>Any help is appreciated!</p>
Find more posts tagged with
Comments
pricher
<p>Hi,</p><p> </p><p>The column header will get repeated automatically for each new column created in the cross tab. If you don't have a label, it will be hard to know which value you are looking at.</p><p> </p><p>To delete the grand total in the bottom right corner, simply delete the fields from the cross tab after they get created when you add the grand totals for the row and column areas.</p><p> </p><p>I have attached a design that is similar to the mock up you posted.</p><p> </p><p>Hope it helps,</p><p> </p><p>P.</p>
oraBirt
<p>P.</p><p>You are awesome! yes, the column headers have to be repeated, and the bottom 3 total values can hide as you taught me.</p><p>Thanks so much! Have a great weekend!</p>