Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created dynamic report. here on selection one field come but I want current selection of two or three fields on selecting dimension. So what would be the Inline for the same
I'm assuming you're using conditional show expression. So to do more than one it would be something like.
=SubStringCount('|' & Concat(distinct DIM, '|') & '|', '|TASKACT_SRNO|')
and you would replace TASKACT_SRNO for each dimension.
When you click and drag in the list box, you will be able to select multiple fields and it will reflect in the details chart. Can share a sample app ?
If you are not able to select multiple in the list box, then make sure you remove the check for "Always One Selected Value".
Hope this helps...
Can you share dimensions and expression of your report, are you controlling dimensions display in the report shown in the middle using dimension enable condition? More info will help to understand the problem.
I'm assuming you're using conditional show expression. So to do more than one it would be something like.
=SubStringCount('|' & Concat(distinct DIM, '|') & '|', '|TASKACT_SRNO|')
and you would replace TASKACT_SRNO for each dimension.
I have used this expression.
=SubStringCount(Concat(DIM , '|'),'TASKACT_SRNO')
Glad you got it working!