Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need background color for each line in the table based on Percentage accumulation reaches till 50% then Green and rest are Yellow. How to achieve this?
Hi,
I found this solution and it works perfectly. Thanks for you effort 🙂
=if(rangesum(above(total sum(IB_COUNT)/sum(Total IB_COUNT),0,RowNo(Total)))<=0.81, rgb(179, 198, 255),
if( rangesum(above(total sum(IB_COUNT)/sum(Total IB_COUNT),0,RowNo(Total)))>=0.80, rgb(255, 255, 204)))
Hi,
Try this;
Aggr(
If(Rangesum(Above(Sum(Percentage),1,RowNo()))<=0.5, green(),yellow()),
(Country, [Target Product],(=Sum(Percentage),Desc))
)
Hi,
Thanks for your reply!!
It's not working for me. I've attached the data for your reference. please let me know if you get any solutions.
Hi,
First, you should add row_number field with RecNo() at script level. Then you can use below expression to do the trick;
Aggr(
If(Rangesum(Above(Sum(Percentage),1,RowNo()))<=0.5, green(), yellow()),
(rn,(=Sum(Percentage),Desc))
)
I will upload the sample .qvd when i go home.
Hi,
Thanks! Awaiting your reply.
Hi,
Check the attached app.
Hi, Still not getting the expected result. I've the Percentage Expression as =sum(IB_COUNT)/sum(total IB_COUNT) and I used the below format as your said.
Aggr(
If(Rangesum(Above(sum(IB_COUNT)/sum(total IB_COUNT)),1,RowNo()))<=0.5, green(), yellow()
),(rn,(=(sum(IB_COUNT)/sum(total IB_COUNT)),Desc)))
Need help on this. Thanks!
Can you share the expected result as excel or image?
Hi,
Thanks for your response so far!
See the below image of which Blue color Background is should be <=80% . Percentage column is sort by largest to smallest.
Hi,
I found this solution and it works perfectly. Thanks for you effort 🙂
=if(rangesum(above(total sum(IB_COUNT)/sum(Total IB_COUNT),0,RowNo(Total)))<=0.81, rgb(179, 198, 255),
if( rangesum(above(total sum(IB_COUNT)/sum(Total IB_COUNT),0,RowNo(Total)))>=0.80, rgb(255, 255, 204)))