4 Replies Latest reply: Jul 24, 2012 8:20 AM by anamika priyadarshini

# how to take difference of time period in dimension

Hi guys,

I am stuck at a position in my project development..I have data in the format below:-

Quarters      A      B     C

Q1             5      6      7

Q2              8      9     10

Q3            10      12   13

Q4              0         3     0

and i need chart and table in the format as:-

Quarters       X             Y              Z

Q2-Q1      -               -               -

Q3-Q2     -               -               -

Q4-Q3     -               -               -

How do i solve this problem?

• ###### Re: how to take difference of time period in dimension

Hi

in Expression side use this expression

=below(Sum(Value)-Sum(Value)

.Try thsi expression

Regards

Perumal A

• ###### Re: how to take difference of time period in dimension

Thanks a lot perumai..

• ###### Re: how to take difference of time period in dimension

Check the attached file

• ###### Re: how to take difference of time period in dimension

Hi,

your expression must be

Below(Total Sum(val1))-Sum(val1)

Greetings

Martina