Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Find attached sheet and qvw , When user select opportunity1 then related information should display in straight table , like this user can select opportunity2 and so ..
Field Lvl Trigger : - vVariable1-> = if(InitativeNo='I1', fieldvalue('Initative', 1),if(InitativeNo='I2',fieldvalue('Initative',2)))
vVariable2-> = if(InitativeNo='I1', fieldvalue('InititiavtiveHost',1),if(InitativeNo='I2',fieldvalue('InititiavtiveHost',2)))
vVariable3-> = if(InitativeNo='I1', fieldvalue('InititiavtiveCharges',1),if(InitativeNo='I2',fieldvalue('InititiavtiveCharges',2)))
Sum($(='[' & vVariable3 & ']')) Expression
=num(Sum({<$(='[' & vVariable4 & ']') = {'Review'}>} $(='[' & vVariable3 & ']')),'$#,##0') ( Set with expression)
Thanks in ADV
Vikas
I donot understand, your Chart Looks good, but is missing an expression
so define an Expression e.g. 1, then goto presentation and hide the 1
thats what you will see (if you select Opp3)
Hi Vikas,
Could the attach file answer your question?
Regards
Miguel del Valle