Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
Please find the attached qvw and try to help me to get this .
Firm No Firm Name Api Weighted%bad
11 royal ask_broker code 41.09%
How can i sum up the weighted% bad for the selection made and show only one result like above.
Thanks ,
can anyone help me on this
Hi
Remove weight from dimension,
Try like this in expression
= Sum(Aggr(sum({<eid=,security_type=,api=>}field_bad)/(sum({<eid=,security_type=,api=>}field_bad)+sum({<eid=,security_type=,api=>}field_good)) * Weight, FirmNum, FirmName, api, Weight))
For one selection it is working. Suppose if there are multiple selections made for Api. How can we get the total weighted in one line .
Example
firm name no Api Weighted
32%
Royal 11 bid_exchange 10%
Royal 11 bid_price 22%
Instead of getting this is there any possibility to get
Royal 11 32%
Hi
Its depend on your dimension, If you used Api in dimension, its show two rows.
Please reload and check the file