cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on.

Answer

If all dimensions are of string data type it will be enough to use the '+' sign between them and the '|'.
If they are not strings yet, you can use the TOSTRING() function before using the '+'
You can also use the Concat function:
Concat(Concat([Product1].''),[Product2]) 
Or  Concat([Product1],[Product2])
Version history
Last update:
‎10-16-2021 07:12 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy