Calculated Dimension

[#1]

Hi,

  I have two dimensions in my chart : Quarter  (Q1,Q2,Q3,Q4) and Year Month (200001,200002,200003......200012)

  I am using line graph In which , I want to display at x-axes both Quarter and YearMonth like  Q1:(200001:200003) Q2:(200004:200005) as labels .

  can anyone help me out to write calculated dimension query trick!!

Regards

Latha

[MK_QSL]

Create a Bar Chart

First Dimension Quarter

2nd Dimension YearMonth

Expression

1) SUM(YourFieldName)

2) 0

Now Go to Presentation Tab and Untick Show Legend

Hope this is what you are looking for..

[#3]

Sorry I will make it clear:

                   I have a dataset with YearMonth (200001,200002,200003......201512) and sum(sales) in one table.

In other table  I have

Quarter:

LOAD * INLINE

[Month, Quarter, Fin_Quarter

1, Q1, Q3

2, Q1, Q3

3, Q1, Q3

4, Q2, Q4

5, Q2, Q4

6, Q2, Q4

7, Q3, Q1

8, Q3, Q1

9, Q3, Q1

10, Q4, Q2

11, Q4, Q2

12, Q4, Q2

];

Now In line graph i want the dimension as 2000Q1,2000Q2,2000Q3,2008Q4,2009Q1.......2015Q4 and sum(sales) as measure/metric

[Anonymous · Accepted solution]

Hi,

try to see if this qvw attached can help you!

KR,

Elena