Chart showing title multiple times in column

I have a chart report as follows:

load(
local!data: rule!rule_Query(),
local!series: apply(
a!chartSeries(
label:_,
data:_,

),
merge(
local!data.title,
local!data.No
)
),
a!columnChartField(
series: local!series,
showDataLabels: true
          )
          )


which shows the titles and Nos from a query rule as a column chart field. it works fine but when the value of some titles are the same, it shows the same title multiple times but I want to show the title only once in the columns... I tried to use count() and wherecontains but then I realised It can't be dynamic... any solutions? I appreciate it...

OriginalPostID-114882

OriginalPostID-114882