Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have used one of the listbox(LB01) as a heading(which is just an expression). now i want that when i select values from other listbox(LB01), the heading, which is just a value in LB01 should not be highlighted. How can i do that?
chech this set analysis expression to ignore the selection.. under your help section..
sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.
sum( {1<Region= {US} >} Sales )
returns the sales for region US disregarding the current selection.
My Expression is:
if(time_bckt_Nm= 'current month' and time_bckt_type= 'current', date(MonthEnd(CAL_DT), 'DD-MMM-YYYY'))
How to use set-analysis now in this expression?
why you dont want them to be highlithed?:)
I don't want them to be highlighted because, it has only one value and i have used that as a heading. So, it looks bad that if i select some values in the some other listbox, so this heading(which is a value in a listbox) also gets highlighted.