Dimitry Rogov Posted October 26, 2023 Share Posted October 26, 2023 Hello,I uploaded data into my dashboard which has various columns. Specifically, I have a column titled "ICAO String" and a column titled "ITP String" which lists location codes and suppliers. However, for each location (i.e.: LAX) it is possible to have two suppliers (i.e.: in the example shown below, for LAX, there is Signature and Atlantic). However, when incorporating this data into a cross table, it only shows one of the LAX suppliers and the other one is missing. How can I fix this issue to show both LAX suppliers?Thank You. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted October 27, 2023 Share Posted October 27, 2023 Hello,So what is the expected end result in the cross table - that each WFS ITP value is listed on a separate row (in the example, Signature and Atlantic), or that it's still just one row but all ITP values for the row are concatenated and shown in a single cell? For the former, add the "WFS IPT" column to your vertical axis in the cross table.For the latter, you could e.g. use an expression like Concatenate([WFS ITP]) on the Cell Values axis to get a Cell Value like "SIGNATURE, ATLANTIC" Example: If that's not it, it would help if you could provide a sample analysis (dxp file) (without any sensitive data of course). Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now