Filtering on the data of a column

[#1]

Hi all,

I did a pivot table and now I'd like to build a listbox based on the values of one of its column. Is there a way to do that?

Thanks a lot.

[#2]

Does someone know if this is possible at least? Thanks.

[#3]

Yes, it depends on the case you could use a "select field" with an expression.

You could try by adding any field to the sheet and then change the origin to Expression.

[#4]

Thanks a lot for your answer. Unfortunately I already tried that without success. The Expression which I want to show in the list box is:

Only({<ReceivedDate={'$(vForecast1)'}>}ShippingMode) & ' -> ' & Only({<ReceivedDate={'$(vForecast2)'}>}ShippingMode)

It produces string like this: "Sea -> Land" or "Air -> Sea"; using the dates contained in the two variables vForecast1 and vForecast2 I'm showing how the shipping mode changed from a date to another one. Now I'd like to filter on that column to show only (as an example) the shipments which changed from Sea to Air mode (string "Sea -> Air").

If I try to copy and paste that Expression in a ListBox, it simply doesn't show nothing. Do you please know a way to do that?

Thanks!

[#5]

It would be easy if I have a copy of the structure, but I will try without it.

Try an expression like this:

AGGR(Only({<ReceivedDate={'$(vForecast1)'}>}ShippingMode) & ' -> ' & Only({<ReceivedDate={'$(vForecast2)'}>}ShippingMode), DIMENSION)

Where DIMENSION is/are the dimensions on your table (or something that makes unique the shipping mode on a row).

Hope it helps!

[#6]

Hi Jeremias, thanks again for your answer, unfortunately it doesn't work. Attached is what I'm working on. I need to have a listbox to filter the values on the column called "Shipping mode". Do you think that's possible? THANKS 🙂 !

[#7 · Accepted solution]

Hey B, this is what I was talking about.

Anyway, I think you should do "CONCAT([Ship Mode],'->')" instead of only(), it will work better and will concatenate all of your shipping modes.

Hope it helps!

[#8]

Yes, ti works! THANKS, THANKS, THANKS

P.s.:I can't guess how you would use concat in my particular case.