Adding in column in pivot table

[rcorcoran]

Hi

I have a pivot chart attached and I want to add in a column before it with the headings in chart 2 on the attached  any help would be appreciated.

thanks

R

Message was edited by: rhona CORCORAN Attachment now has image of the way I want the chart to look.

[sunny_talwar]

Not entirely sure what you are trying to do? Would you be able to re-explain your requirement?

Best,

Sunny

[rcorcoran]

Hi Sunindia

I have now attached a document with image of example of what I need

Thanks

[sunny_talwar]

Why don't you create a inline table in your script and use the two new fields instead of ValueList() function?

LOAD * Inline [

Column1, Column2

Home Care Packages, Test 1

Home Care Packages, Test 2

Home Help Hours, Test 3

Nursing Homes Support Scheme (NHSS), Test 4

Public Beds, Test 5

];

and then use Column1 and Column 2 as your dimension

HTH

Best,

Sunny

[rcorcoran]

I am not sure that will work because of the way I have to calculate the expressions??

R