Variable not working in a drill down table

[helen_pip]

  Hello

I have a table which is a drill down table.  I have a variable which simply is =Count(ID)

When I place the variable in the expression, my table does not return any values

Is it possible to use variables in a drill down table?  If so could some kindly let me know what I am doing wrong

[sudeepkm]

Please try $(v_Count) in your expression.

[sudeepkm]

if you want to

1. store the count of ID value in a variable then use like below

v_count = count(ID)

else if you want to store the count(ID) text in a variable for reuse purpose then use like below

v_Count = 'count(ID)'

Use $(v_Count) in your chart expression

[helen_pip]

Hello Sudeep

Thank you for your reply.  I have tried your technique and unfortunately I get the same figure for every row.

I.e. in the example above I get the figures 86 for every row in the table

Do you have any further suggestions?

Kind Regards

Helen

[Anonymous · Accepted solution]

Hi Helen,

Take a look at the attachted document.

Is that what you are looking for?

Dennis.

[sudeepkm]

You can declare your variable like below.

v_Count = 'count(ID)' in the Variable Overview window

[helen_pip]

Hello Dennis

Thank you ofr your help.  This works perfectly.  All I need to do was take of the equals sign

Thanks

Helen

[helen_pip]

Hello Sudeep

I have solved the problem.  The outcome was to just take the equals sign off when declaring the variable

Thank you for your help and suggestions

Helen