Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a bar chart, table and filterpane. I want to add the reference line for the bar chart in such a way that the reference line should be based on the filterpane, if no selection is done the reference line should show the complete value, If selection is done it should show only value related to that selection. The important criteria is reference should not change based on the other selections except the filterpane.
thanks,
mukesh
Then it should be written in the other way,
sum({<x=,y=,z=,Subject = {$"GetFieldSelections(Subject)"}>} your_measure_field)
Hi,
here is some pictures below show you how to do it, it based on random values but try it on your real ones.
x,y,z is for sample there are n number we cannot write all the conditions for all the fields in it right?
Better you store all the field you used in the application by creating the variable like:
vNullification
field1=,field2=,field3=,etc
and use the expression
sum({<$(vNullification),Subject = {$"GetFieldSelections(Subject)"}>} your_measure_field)
unfortunately, there is no better choice other than this to my knowledge.
could you please make an example why you are saying it's not working ?
could you show me the expression you are using in reference line ?
can u xplain how we eliminated all the selections expect subject. Can u once check it in your local and just conform
the expression shown to you does exactly what you asking for.