I would like to add a comment column to my pivot table but I really have no clue how to do that. My script looks like this:
LOADCountry, Brand, Perspective, [Value Driver], [Definition KPI], [KPI Formula], [Definition in words], [Year Value 2011], [Budget/ Target Value], FC, FY, delta, [Group Target], [KPI Type], [Level of fulfiment of local targets], [Level of fulfilment BP of 15], Fulfilment, [choosen target]
FROM ;
This is not working, already tried it. So how can I insert an input field into a pivot table that is preverably not loaded over the script?
Your input field needs to be tied to your data for it to display in your table. Try this,
inputfield comments;
LOADCountry, Brand, Perspective, [Value Driver], [Definition KPI], [KPI Formula], [Definition in words], [Year Value 2011], [Budget/ Target Value], FC, FY, delta, [Group Target], [KPI Type], [Level of fulfiment of local targets], [Level of fulfilment BP of 15], Fulfilment, [choosen target],
''AScomments
FROM [d:\Dokumente und Einstellungen\.;. ......)
You may need to use an aggregation of the comments in your pivot table. You can do that using the concat function in the expression like this:
The quotes are 2 apostrophes rather than a set of double quotes. You are simply initially setting the comments field to a zero length string. You could instead have:
Sorry, my mistake, you can't use concat() in a table and it oporate as an input field. You can only use inputsum() and inputavg() for numerical values so they won't work for comments in a pivot table.
You can only add them to a listbox or straight table.
