how to take difference of time period in dimension

[#1]

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?

[perumal_41 · Accepted solution]

Hi

in Expression side use this expression

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

.Try thsi expression

Regards

Perumal A

[sivarajs]

Check the attached file

[brenner_martina]

Hi,

your expression must be

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

Greetings

Martina

[#5]

Thanks a lot perumai..