question about bar offset

[Anonymous]

Hi all,

I need to create a bar chart which shows the gender/age structure of the readers of editions.

I need to set a bar offset between men and women.

But it fails to work as required.

Could you look at the file attached and give me a prompt?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

How about this:

=If(WildMatch(Only(Group), 'women*') and WildMatch(Above(Only(Group)), 'women*') = 0, 3)

[Anonymous]

Thanks, Sunny!

The solution is simple and nice. I appreciate.