Adding symbol in Pivot table

[rahuldhomane]

Hi,

Is there a way to add symbols like Tickmark and Cross in one particular column in  pivot chart instead of binary values like 0 or 1?

[jirazazabal]

Have you checked this one? 

https://community-old.sisense.com/hc/en-us/community/posts/221225548-Add-Image-Indicator-to-a-Pivot-...

If not, you always can do it with JS

Hope it helps

[rahuldhomane]

Thanks @jirazazabal 

[Alek_qbeeq · Accepted solution]

Hi @rahuldhomane ,

if you already have column with 0 and 1, you can use widget script to replace values.

const myTarget = {
 type: ['value'],
 values: [
  {
   title: 'Total Cost' // put here desired column
  }
 ]
};


widget.transformPivot(myTarget, function(metadata, cell) {
        if (cell.value = 1) {
     cell.content = "✔";
       } 
        else if (cell.value = 0) {
     cell.content = "✖";
       } 
});

this script uses pivot2 api  - Pivot 2.0 API 

- Alek
[email protected]

[rahuldhomane]

Thanks @Alek_qbeeq . It worked and I got what I expected. Only change needed was

(cell.value = 1) to (cell.value==1)
(cell.value = 0) to (cell.value==0)