Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi~~i want to know that is it possible to remove "implemented" in the listbox of "Purpose".
Do i need to change in script? But in the script, it just show like this:
So, what should i do?
=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )
OR
=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )
use Where Condition
Table:
Loald *
From yourSource
Where Purpose <>'Implementation';
Just change your list box to use an expression, add the following as your expression =if(Purpose <> 'Implementation', Purpose)
Use where Clause in the script :
WHERE Purpose <> 'Implementation'
OR
Use Expression in List Box:
=if(Purpose<>'Implementation',Purpose)
Yes in list box in expression type like this
In Front use like
1.
If(Purpose='Recovery','Recovery',
If(Purpose='User Request','User Request'))
Or you can write in list box expression
2.
If(Purpose <>'Implementation',Purpose)
3.In the load script like
Load
Fields
..
..
From Location
Where Purpose <>'Implementation';
Regards
Go to list Box and then in general tab in drop down go to expression and then in expression you have to write this
=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )
OR
=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )
Thank u for ur help! But it's not correct.May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"
Thanks! But it doesn't work. May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"
Take Month as Dimesion and take two expressions:
Count({<Purpose={'Recovery'}>}Purpose)
Count({<Purpose={'User Request'}>}Purpose)