Showing results for 
Search instead for 
Did you mean: 
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.
Solution: 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:
Or  Concat([Product1],[Product2])
7 - Data Storage
7 - Data Storage

Thanks for sharing this. this is really helpful for me. I apply this in my  project during blue prism certification. I really appreciates your solution. 

Version history
Last update:
‎03-02-2023 09:52 AM
Updated by:
Community Toolbox

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

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: