Highlighting in Pivot Tables

[kukuk52]

I believe this has been asked before, but is there any way the KTL could be used to highlight specific cells in a Pivot Table if the underlying data meets a particular criterion (sort of like using _cfv and the ktlRefVal in a grid)? For example, I have a pivot table of recurring bills that displays the total amount owed for a given month in my pivot table. I want to highlight those cells green if the bill is set to "Paid," yellow if it's set to "Billed," and red if it's set to "Delinquent."

[cortexrd]

Hi Dan,

_cfv is not directly supported in Report views at the moment, and can't tell you when it will.

But you can get around and do it by using the _style keyword:

These are the keywords strings I used:

_style=[background-color: orange], [ktlTarget, $('#${viewId} td:textEquals("Anny Lasham")')]
_style=[background-color: lightblue], [ktlTarget, $('#${viewId} td:textEquals("Mickie Brammer")')]

But you can easily modify them to suit your needs.

Norm

[kukuk52]

Thanks, Norm! In my case, I'd like to highlight a value field based on some information that doesn't show up in the pivot table. In my example, I'd have customers in each row, months in each column, and total amounts displaying as the calculated value in the pivot. The records that this pivot is based on have a field called "payment status," which I'd like to use to highlight the total amounts owed. I believe _style won't work in this example. Is that right?

[cortexrd]

I'm afraid it won't work. I also tried the _cls keyword since it offers more flexibility with the ktlCond option, but even then, I still can't achieve what you need.

The only solution would be to code the implementation manually. If you really need this badly, I can assign Charles to it, but it won't be free. You can also give it a try yourself with AI and some HTML screen grabs to explain what you need.

Wish I could help more,
Norm