Can anyone solve this---(How to use difference(Substraction) in calculated dimenssion)?

[#1]

Hi All,

I have a dimenssion(Q8-Q1) which I want to modify as below:

Dimenssion	A-B	A/B
Q8	12	50%
Q7	24	29%
Q6	25	94%
Q5	7	52%
Q4	64	94%
Q3	44	12%
Q2	35	33%
Q1	43	73%
Q5-Q1	-36	-21%

the last row showing difference of Q5 and Q1.

I have fields as A and B, and what you can see here (A-B, A/B) are calculated metrices. So, like A-B and A/B there are 20 others.

Why I am telling you the above things is b'coz i dont want to write expressions 9 times(Q8, Q7....Q1, Q5-Q1) for each calculated metric(A-B).

If anyone has any idea plzz let me know, any sort of help will be highly appreciated.

Thanks

Sagar Gupta

[suniljain]

can you provides details of business req on Q5-q1 ?. what will be other requires expression ?.

[#3]

Hi Sunil,

You don't worry about rest of the expressions as it will be the same more or less, the only thing i want is to show Q5-Q1 values for all my calculated metrices.

It will be much better if you can be in my skype frnd list.

Regards

Sagar Gupta

7411502937

[#4]

check this (island table + calculated dimension)

*** expressions i made need to be rebuild to be correct  (i just show an idea)

[#5]

Hi Pari,

Thanks for the reply.....

You have changed the expression according to my requirement, but i don't to change my expression coz' i have lot many. Is there any other way by which I can get the values without hard coding in the expression. Please tell me how can I write the calculate dimenssion so that the values will be automatically pulled for (Q5-Q1).

Regards

Sagar Gupta

[sivarajs]

Try this expression

below(Sum(Field)-Sum(Field)

[#7]

Hi Sivaraj,

I guess you misunderstood my requirement,  I am explaining you again what I am looking for.

All my metrics will show the values for respective quarters(Q1-Q8), now I want my dimenssion to be as below:

Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q5 - Q1. the newly added Q5-Q1 should not only display in the table also it

6    5      3    7    9    4     7    2        3

should give values as well.

Still if you are not clear then plz check for the sample file which i uploaded in the start of the post.

Any help will be highly appreciated

Regards

Sagar Gupta

[#8]

Hi Sivaraj,

Just wanted to know that calculated dimenssion of this kind will work or not( some modifications required)

=

if(Quarter_ID<>'Q9', Quarter_ID, Quarter_ID=('Q5' - 'Q1'))

Regards

Sagar Gupta

[sivarajs]

if(Quarter_ID<>'Q9', Quarter_ID, Quarter_ID=('Q5' - 'Q1'))  It wont assign 'Q5' - 'Q1' to that field but then following will display

if(Quarter_ID<>'Q9', Quarter_ID, 'Q5' - 'Q1') 

[#10]

Hi,

Ya i know, my moto is not only to display(Q5-Q1) but also to make it functional, so that i dont have to hard code my Expressions.

What you have mentioned above will only display(Q5-Q1) and it won't be giving values for Q5-Q1

Regards

Sagar Gupta