Data Presentation in Pivot Chart

[Anonymous]

I have to show 2-QTR which will be the sum of 0,1,2 and 4-QTR which will be the sum of 0,1,2,3,4 fields and so on. I have got the calcs for this, but my question is how will I display it like the above format. Adding a new expression will not help because it will display the records as new row.

[Gysbert_Wassenaar]

Create a new table with a new dimension in the script:

LOAD * INLINE [

OldDim, NewDim

0,0

1,1

2,2

3,3

4,4

5,5

6,6

7,7

8,8

9,9

0, 2_QTR

1, 2_QTR

2, 2_QTR

0, 4_QTR

1,4_QTR

2,4_QTR

3,4_QTR

4,4_QTR

5.4_QTR

etc...

]

Then use NewDim as dimension in your pivot table instead of OldDim

[Anonymous]

Hi,

Thanks for your reply. I think above solution will not work because 2-QTR,4-QTR,9-QTR are not straight sums. Somewhere these show averages and for some other metric these show sum and so on.

Moreover I am using ASOftable to get quarters