pivot table - up and down arrow - based previous month value

[jithu]

I have a pivot table like the above one. I want to show ^ and v arrows with red and green color based on the previous months value. 

how can I achieve that ??

[nam]

you can simply try the below:

Custom format on the measure

▲ #,##0;▼ #,##0

 Then add in Text Color Expression:

if(Value=1,Green(),Red())

this is fairly simple and neater option in a pivot table

[nam]

you can simply try the below:



Custom format on the measure

▲ #,##0;▼ #,##0

Then add in Text Color Expression:

if(Value=1,Green(),Red())



this is fairly simple and neater option in a pivot table

[jyothish8807]

You can also explore vizlib pivot chart extension, it has inbuilt feature to add the symbols.

https://www.vizlib.com/pivot/

[jithu]

Tried but didn't work. 

choose Custom format on the measure and enter the below text. But for all the values it is just  ▲ not showing the down trend

▲ #,##0;▼ #,##0

What is the value parameter in if condition . I assume the agg of revenue

[jithu]

But this is not free extension .... would like to achieve this from existing extension ... any help would be appreciated.

[jyothish8807]

Can you try writing a if condition in the custom format section ? I dont have QS with me so cant check.

May be something like this:

if(sum(Sale)>0,▲ #,##0,▼ #,##0)

[jithu]

Sorry buddy not working

[jithu]

Thanks, I am able to set the color based on the above row.... but the up and down symbols are not working with custom format... always showing the ▲

used the following text in format : ▲ #,##0;▼ #,##0

tried with if condition but if condition is not accepted in the format pattern

any other solution please