Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not entirely sure what you are trying to do? Would you be able to re-explain your requirement?
Best,
Sunny
Hi Sunindia
I have now attached a document with image of example of what I need
Thanks
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
I am not sure that will work because of the way I have to calculate the expressions??
R