How to target a specific cell/column to change the column in a pivot table?

Question

I have a pivot table where I am trying to turn the "Activity date for billable time" light green (can be any color) in my widget edit script, along with its corresponding value from another column, 2025-08-18, in this example. I have tried a couple of different script but nothing seems to work: (function () { // === settings === var VALS = 'Activity date for billable time'; // sub-header text to match var COLOR = '#e6f4ea'; // light green var MAX_TRIES = 40, RETRY_MS = 150; // --- tiny helpers (...

Astroraf · Accepted Answer

Solved the issue: The order of the scripts and then us // 1) Color the column's sub-header cell (row-1 "member"): widget.transformPivot( { type: ['member'], // header cells axis: 'columns', // match column members columns: [{ dim: '[Program_Assessment_Response_Question.Program_Assessment_Question_Version_Name]', members: ['Activity date for billable time'] }] }, function (metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = '#e6f4ea'; // light green cell.style.borderRadi...