Help needed on Dimenssion..

[#1]

Quarter	A	B	C
Q8	95	58	334
Q7	75	56	47
Q6	4556	87	87
Q5	78	3466	987
Q4	4568	65	5
Q3	8	4	231
Q2	567	587	65
Q1	9	353	78

I have my table as above and i want it to display the data as below:

Quarter	A	B	C
Q8-Q7	95	58	334
Q7-Q6	75	56	47
Q6-Q5	4556	87	87
Q5-Q4	78	3466	987
Q4-Q3	4568	65	5
Q3-Q2	8	4	231
Q2-Q1	567	587	65

[perumal_41]

Hi Sagar

use this Expression

=fieldname&'-'&num(replace(fieldname,'Q',''))-1.

this useful for u

Regards

Perumal

[#3]

Do u mean this: 

=

Quarter &'-'&num(replace(Quarter,'Q',''))-1.

[perumal_41]

Hi sagar

sorry .some missed in Expression now use this expression

Quarter &'-'&'Q'&num(replace(Quarter,'Q',''))-1.

[#5]

Hi Perumal,

I guess you miss understood my problem.

I wanted my feids to display the related values

For eg: Q8( A=24)

           Q7(A=18)

    Then my Q8-Q7 should give(6)

Regards

Sagar Gupta

[perumal_41 · Accepted solution]

Hi

in Expression side use this expression

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

.Try thsi expression

Regards

Perumal A