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)
Drill through in cross tab
gowtham
<p>Hi Team,<br>
<br>
Is it possible to drill through specific values in summary field of cross tab?<br>
<br>
I need to provide drill through for summary field in cross tab but based on certain row group values that drill through should be disabled.<br>
<br>
For eg:</p>
<p>consider below cross tab structure,</p>
<p> </p>
<p> Year </p>
<p> 2015</p>
<p> </p>
<p>Number car van bus</p>
<p>1 <u>100</u> <u>200</u> <u>150</u> -> for 'Number 1' summary values '100,200,150' having hyperlink</p>
<p>2 101 198 140 -> No hyper link for 'Number 2'</p>
<p> </p>
<p>Thanks in Advance.</p>
Find more posts tagged with
Comments
pricher
<p>Hi,</p>
<p> </p>
<p>You can add the following script to the onCreate method of the Data item where you have the hyperlink:</p>
<pre class="_prettyXprint _lang-js">
if( reportContext.evaluate("dimension['Group']['PRODUCTLINE']") == "Planes" ){
this.action = null;
}
</pre>
<p>This will remove the hyperlink for all aggregation values for product line Planes.</p>
<p> </p>
<p>I have attached a sample report.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>
gowtham
Thanks Richer.. It's working