count shows incorrect in chart

[arulsettu]

hi count(id) and for ratio count(id)/count(total id)

count(total Id) is incorrect.

in straight table i checked.in properties expression tab if i use Expression as total it showing correct.

how to do this bar chart.

Note: i am using cyclic group in dimension

expected result

[arulsettu]

Bill Markham ‌ can you take a look

[MK_QSL]

use this.. already replied you in previous post.

[sunny_talwar]

Are you looking to fix the straight table or the bar chart? They both have different expressions and I am having a hard time understanding what are we trying to fix here

[arulsettu]

one problem bro.  if i clear the selection vech count is changing. only i select year 2016 it showing correct values. can you please take look

[arulsettu]

only in bar chart Sunny

[sunny_talwar]

May be like attached

[arulsettu]

Sunny you didnt use cyclic group in bar chart?

[MK_QSL · Accepted solution]

use this !

[arulsettu]

{"=Rank(COUNT({1<BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}BW_VEH_ID))<=10"}

1 -> this the change u made right?