Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
Do anyone of u know how to use "<>" (not equal to) in set analysis???
Please Reply
Thanks
Ankit
Field -= {2}
Field -= {2}
Hi,
You can use this
Sum({<Year -= {2012}>} Sales)
Above expression excludes 2012 from Year field. You can use <> like this.
Regards,
Jagan.
sum( fieldname-={value},measure)
this may gives Red lines but will work
or
sum( fieldname={*},measure)-sum( fieldname={value},measure)
hope this helps
Thanx mwoolf... it's working