Apd2024
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Pivot Table Formatting to Highlight Entire Rows
Hi, I am trying to create a Pivot table widget, where certain rows are highlighted containing words "Conditional" and "Pending". These two data points are under a column named as "Status". So far, I have come up with this but it seems to not work: widget.on('ready', function() { // Define the column index of the "Status" column var StatusIndex = pivot.getColumnIndexById('Status'); // Loop through the table rows and highlight the rows containing "Conditional" or "Pending" var rowEls = pivot.tableElement.find('tr'); rowEls.each(function() { var rowEl = $(this); var StatusCell = rowEl.find('td:eq(' + StatusIndex + ')'); var StatusValue = StatusCell.text().trim(); if (StatusValue === 'Conditional' || StatusValue === 'Pending') { rowEl.css('background-color', 'yellow'); } }); }); Can someone point me in the right direction.1.8KViews0likes1CommentCustom Column for Pivot
Hello all, I am trying to create a custom column with the following conditions: IF ( (SUM([Sale Price])<361000, [Sale Price ]/1.2, SUM([Sale Price ])), (SUM([Sale Price])<450000, [Sale Price ]+21350/1.3, SUM([Sale Price ])), (SUM([Sale Price])>450001, [Sale Price ]/1.5, SUM([Sale Price ]))) However, I am getting "syntax error: unexpected token "IF" Any w=help would be appreciated. Thank you.Solved2.5KViews0likes1Comment