Bar chart problem

[djallelsadki]

Hi,

I have the following bar chart :

dimension "indic" which is set to "Total" and "Detail"

and a second dimension "Category" which has the values: "Chicken", "Frozen ",....

my formula is:

=if(indic<>'detail',

    count({<Distributeur=>} num_ligne)/count( {<Distributeur=>}Total num_ligne)

           ,count({$<Catégorie>}num_ligne)/count( {$<Catégorie>}total num_ligne))

here's what I get

by selecting multiple distributors :

The problem is here :

when I select a single distributor, i get this

values ​​belonging to the total appear

whereas what I want is :

I hope this is clear,

thanks,

Djallel Sadki