Using Multiple Fields in Comparative Analysis

[#1]

Hi All,

We have a chart where we are analysing the quantity of product produced at plant level hence we are using only one field in Comparative Analysis ie Product Name. We have created the Alternate state for this filed and the chart is showing correct value.

Now, we would like to analyze the same chart based on two fields:

1. Product Name

2. Region Level

I need assistance on how do we do this in Comparative Analysis.

Thanks in Advance

[israrkhan · Accepted solution]

assign regional level list box to same state, that you have created for Product.

add your [Regional Level] in chart, second dimension(chart already have assigned alternate state)

are create new chart and assign alternate state.

and in the expression do like

sum({State1} Value) for alternate state

sum(value) for your default state, to which you have to compare.

[#3]

Thanks it worked !