Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two straight tables which I display only the totals by hiding other columns and rows. These totals are a result of several complecated expressions involving 'Above function' and 'Sorting', hence cannot be recreated in the graph expressions. I want to get these two total values to a bar graph. Can I reference these totals outside the straight table? i.e. in a variable?
Any ideas?
Can I have the demo application sot that I can exactly tell you how to do it.
But for simply try to use all the those expression as one and implement it in the Bar Chart.
Or you can also do one thing that in bar chart there feature of the "Invisible". Try to use that feature.
Regards,
Nitin Jain
Thanks Nitin.
I'm not sure how to implement an expression like below in the bar expression, because it uses Above function which relies on sort order of the table.
if((SEL_MapZoneGuid-Above(TOTAL SEL_MapZoneGuid))>0 and (TRIPEVENT-above(TOTAL TRIPEVENT))=1,1,0)
A quick workaround I found is to use VB scripts to load the table values into variables and use them in the bar graph.