showing line for all regions irrespective of region selection

[#1]

Hi,

I want to show the trend line for all 3 regions. it should be independent of region selected. i have done that for bar.but for line its not working.

help on this would be appreciated.

[Gysbert_Wassenaar · Accepted solution]

Try

=if(getselectedcount(Division)=1,Sum({<ID=>}[Time to complete])/Sum({<Division=>}Total [Time to complete])*SUM({<ID=>}Resource),SUM({<ID=>}Resource))

[#3]

Thnaks..it worked