Add information column in Pivot and calculate with it's value

[george55]

Hi all,

Have 3 questions regarding with pivot tables. Maybe some of them are reasilzable:

1) Would like to add an additional column which should not be part of the pivot table. It is only an "information" column. See below column "Person days". If possible to add this column in front of Total column.

2) Highlight all columns with values that are higher then person days on a monthly base. E.g. Teammember 1 had in March a higher value then 10 (his max monthly person days is 10 days). So the background colour becomes red. 
Do know how to implement on a dimension-level (in this case on a row-level), but don't know to implement it columnwise. My formula: 

If(Dimensionality()=1 AND (Interval(Sum(Timeduration), 'd') / 8 * 24) > 10, Red())

3) Low priority: Use value in information column (person days). Instead of using hardcoded like above"> 10, Red())"  could use "10" from the person day column. 

Thanks for some inputs.