Use other_than_the_selected fields for a display?

[datanibbler]

`Hi,

in my Chart I have the Dimension "Month", which,  however has the Format "YYYY-MMM" - that way I can Display the last 9 or 10 months in the Chart.

Now I'd like to Display in the caption what has been selected - if one or more months have been selected, another Dimension  becomes active in the Chart, the new Dimension is the cw and then I'd like to Display in the caption the month(s) These belong to.

By Default, when I select two months and I use the >>Concat<< formula I know, the result Looks like this

>> Month: 2017-Mar, 2017-Apr <<

=> I can cut out that prefix no Problem, I have the formula anyway to decide which Dimension is to become active.

<=> The issue is, I'd like instead to Display >> Mar, Apr << and the year separate.

I do have the months without the year, that's another field in my calendar, but I cannot get that using >>Getcurrentselections()<< since no selections have been made on that field.

Can anyone help me there?

Thanks a lot!

Best regards,

DataNibbler

[stigchel · Accepted solution]

Maybe I'm misunderstanding you, but why not simply use

Concat(DISTINCT MonthWithoutYearField,',')

[datanibbler]

No, you're not 😉

Sometimes it's the most simple things we just don't see. That will do nicely 😉

Best regards,

DataNibbler