Chart according to data from a field of a table

[#1]

Hello everyone,

Can you help me to know, how can I display data in a chart only for a field of a table ?

For example, I have a table "Country" which have "France, Allemagne, Italie, ...". In my chart, I only want to display datas from France, without any selection from the user.

Thanks for your help !

[#2 · Accepted solution]

Use Set Analysis...

For example

Sum({$<Country={'France'}>} Amount)

[alexandros17]

If your expression is for example sum(sales) then your expression will be:

Sum({$ <Country={'France'}>}  Sales)

Let me know

[#4]

I am dizzy !

Thanks you both for your response.