Two stacked bars with 8 expressions

[#1]

Hi All,

I have to create a chart in which there is no dimension but 8 expressions(4 for Activity & 4 for Sales). Now i want these 8 expressions to divided into two stacked bars with 4 expression each(attached image for reference). Is this possible or am i being too ambitious?

[Gysbert_Wassenaar]

Use a (calculated) dimension for the two bars for Activity and Sales and use four expressions for the bar segments.

[#3]

Actually, I can not create a calculated dimension for Activity & Sales and since the expressions are different, i can not club the dimensions together.

[Gysbert_Wassenaar · Accepted solution]

Of course you can:

=valuelist('Activity','Sales')

The expression can be changed in:

=if(valuelist('Activity','Sales')='Activity', ...activity_expression_PP_here..., ...sales_expression_PP_here... )

[#5]

Thanks a lot. It worked.