Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using set analysis in expression to function based on only one list box selection.
If am selecting any value in order total field, based on that only, value should changed. when I am using another filter it should not be changed. For me it is working as normal filter.
Can all please help to solve this issue.
I am using the expression as follows
=sum({1<[order id]=p([order id])>}[order total])
please find the attached qvw file.
Maybe this:
=sum({<[customer name]>}[order total])
Try this:
=sum({1<[order id]=$::[order id]>}[order total])
You may read this: Ignore all selections except few fields using Set Analysis for better understanding.
I think Terescos solution is much better than mine 🙂
Thank you so much Frank
I think you should consider Terescos solution as the correct one, Because if you have a lot of Filters his solution is neglecting them all except the one inside the setanalysis function!
Thank you so much Tresesco. Very much useful for me.