Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have an issue with Current selection box.
The issue is : i have one stright table and that related values also available in other sheet also.
So i select one value in stright table in other sheet the current selections shwng as two selected values?
how to overcome this?
Thanks in advance
suresh
awesome issue...i was facing. now its wrkng fyn....but the trigger is nt wrkng for dat project1
Where is your trigger ?
Is it based on the selection of the "Project1" field? Because now "Project1" is not anymore selected, it is "id_prj" that is selected.
yes my trigger on project1 only.... on select event trigger....
how to retrigger to work tht property also?
Did you find why you have multiple id_prj for one Project1?
Try to add a "Table Box" with both dimensions and select one Project1 to see what values you have for id_prj.
i hve exported this prj_ID and project1 from tablebox to exel...see the data
4702 | Instant Issuance |
5211 | BIG DATA |
5225 | POS |
5261 | H/W Replacement |
5283 | Rate SuperMarket |
if i select one prjct it shwng only one id
Ok, if you are certain that there is only one "prj_id" per "Project1". Also I don't understand why Only(prj_id) didn't work before.
You could redo this previous solution
Or you could remove the dimension "prj_id" and add a new measure Only(prj_id) and finally moved it manually before "Project1".
But use MaxString(prj_id) instead of Only(prj_id).
After you have finish to apply the solution above, to be certain that there is only one "prj_id" per "Project1" you could add temporary in your straight table the following expression:
If you have 1 for each row, you have ony one "prj_id" per "Project1"
thnx alot Fatoux,
awesome.
As both are givng exct solution.but need to wait till monday....
as it they want this or any other chnges come back to u...
Best
Suresh