adding alternate dimension in a multi dimensional stack Bar graph.

[Architect]

Below is the problem I am facing--

I have a Stack Bar graph.

there are 2 Dimensions-

1>Product_Type (X axis)

2>Store_Type

and 1 Dimension - Sum(Sales).

I want to add two alternate dimensions 'Customer_type' and 'Sale_type' to the "product_Type"  only.

So that we can select any 1 of the 3 dims from X axis.

But "Store_Type" remain a single entity.

Is it possible to achieve.

[mato32188]

Hi @Architect,

if you want to "freeze" Store type as a second dimension and change only Product Type by other two alternate dimensions, it is not possible. User can freely change whatever dimension he wants. In such cases I prefer to use a "note" below chart heading with info that second dimension is rather to be not changed due to unexpected results.

Or if you do not want to use this approach, you can create input object with drop-down list using variables and call predefined variable values.

BR

m