Dynamic Segmentation - Age Band - Headcount showing repeated values for each age band

[PowerAuto82]

Hi,

I posted a smilar post where I wanted help with a Dynamic Age Banding issue, which looks like it is now fixed.
The file (see link below on onedrive)has a visual Clustered column chart (Headcount by Age Band) where I want to show the Headcount for each Age Band, this will also change results when the Years have been changed, but the Headcount is showing the same value of 11 for each Age Band.

Why is it not showing the what the headcount is for each Age band category?
Any ideas?

https://1drv.ms/u/s!AkzJiHUi2WtQfgNdg_KU0E0nQ-k?e=qcEY95

Thanks

[amitchandak]

@PowerAuto82 , Refer how I have done it here

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

I will also try to check the file you shared.

[PowerAuto82]

Hi @amitchandak , Thanks for your reply, I do not think the youtube link helps to what I am trying to achieve?