Interpolate Points in a cross-tab

[nigelstewart2]

I am looking to interpolate points in a cross-tab as in the example below.

Data Table

Column a Column b

1 2

1 4

2 6

2 8

Cross-tab in report

Column a Column b

1 3

2 7

Column b is an average.

How would I insert a value in Column a of the cross-tab of 1.5 (that does not exist in the data) and then have the column b value be 5 (midpoint of the averages of values 1 & 2)?

[nigelstewart2]

Sorry, the tables did not paste very well, the data is as follows:

Column a

1

1

2

2

Column b

2

4

6

8

[Former Member]

Hi

Create a formula field to calculate the average.

Use this formula field in "Show values" in your cross tab.

Hope this helps!!

Regards

Sourashree

[nigelstewart2]

Thanks for your response Sourashree, however that will not solve the problem, I need to insert a vaule in a cross tab that does not exist in the data.