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
If the condition is based on YoY growth, this needs to be the first item in the values shelf on the widget (first column in the pivot).
The limitation I mentioned in the response is that the Transform Pivot api works left to right, and as we're only learning about the condition when we hit the cell the condition lives in - we can't easily then go back in time to tell the previous cells (to the left) that we need to color them.
Putting YoY growth as the first item on the values shelf should fix this.
Let me know how you go?
Thanks,
Daniel
RAPID BI
RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons
