Multiple dimensions in a simple bar graph

building reports webintelligence
1

Hi All,
We have a requirement-
The same bar chart should show values for the following dimensions:

  1. Last Financial Year
  2. Last to last quarter
  3. Last quarter
  4. Quarter to Date

We have to use a simple bar graph, not a grouped bar graph. Is it possible to achieve the above solution without using a derived table query? Am using WebI3.1

Screenshot is attached.
Thanks & Regards
Swasti
Bar Graph.JPG

swasti (BOB member since 2006-02-27)

2

have you tried Combined Query?

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

3

Combined query will require same columns in the select clause.

Regards,
Swasti

swasti (BOB member since 2006-02-27)

4

Need not be, Just keep the dimension in the same position.

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)