Stacked Chart Problem

[#1]

Hi All,

I am 6 Metrics..................Such as

METRIC1, metric2,

METRIC3, metric4,

METRIC5, metric6

I want to have 3 bar charts such as metric2 lie above METRIC1 (in stack form)

similarly, metric4 above METRIC3 and so on............

I have attached the snapshot of the requirement............Plz see it.

How to acheive this................

[#2]

try

=Pick(Match(metric, 'metric1','metric2','metric3','metric4','metric5','metric6'), 'one', 'one','two','two','three','three')

as a dimension

[#3]

Hi Pari,

Thanx for reply.............

What is metric here?

And in expression, I will put the 6 metrics ??

Plz Suggest................

[#4]

metric is a field name containing all of your metrics (1 to 6)

see att file

[#5]

Thanx for reply again,

These 6 metrics are coming from database as separate fields and I m rolling up the data(Values) of these metrics(Fields) to obtain the result.

So I cannot have separate field and keep those metrics in it.

Is there any other approach ??

Thanx Again

[#6]

check this

[#7 · Accepted solution]

or check this one (second chart)

[#8]

Superb !! Thanx a Alot Pari...........What An Idea...............