Color change across whole row in pivot table
I was wondering if it was possible to edit the the color of an entire row of a pivot table off of one conditional cell. I have found another post with the same problem but the script provided there d...
Forum Discussion
Hello Daniel,
Thank you for your response. This script you provided me is working to an extent. It is fully coloring some of the rows that match the conditions I set in the script, while also still only highlighting some single cells. I will attach a screenshot to show you what I mean.
Thanks
Thanks for the chat this morning Jack_Machesky ! Was great to catch up to talk through.
As discussed - the cell that includes the 'rule' should be the first item in the values panel. As transformPivot works from Left to Right, Top to Bottom, we need to push the rule to our storage before we can rely on it to do our formatting.
Additionally, we discovered that you can add multiple conditions (rules and colours) by copying the entire script again in the widget script, find & replacing widget.conditions for widget.conditions1 or 2... etc. and then adjusting both the style and rule appropriately.
Please don't hesitate to reach out in the future if we can help!
Thanks,
Daniel
RAPID BI
RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons
