Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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................
or check this one (second chart)
try
=Pick(Match(metric, 'metric1','metric2','metric3','metric4','metric5','metric6'), 'one', 'one','two','two','three','three')
as a dimension
Hi Pari,
Thanx for reply.............
What is metric here?
And in expression, I will put the 6 metrics ??
Plz Suggest................
metric is a field name containing all of your metrics (1 to 6)
see att file
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
check this
or check this one (second chart)
Superb !! Thanx a Alot Pari...........What An Idea...............