Need help on Creating pivot table with arrows

[venkanna_info]

Make a pivot table taking County, Sales office, Employee name and measures as TY YTD sales, LY YTD sales and Year salary.

Color code: TY YTD<LY YTD, RED arrow down

Color code: TY YTD>LY YTD, Green arrow Up

I am facing problem while creating arrows as per above condition.Can anyone help me on the same.

Thanks,

Venkanna

[Anil_Babu_Samineni]

Normally, we can write like below

If(TYYTD Expression < LYYTD Expression, RedAroowImagePath,

If(TYYTD Expression > LYYTD Expression, GreenAroowImagePath))

[ahaahaaha]

Hi Venkanna,

May be like this

Regards,

Andrey

[venkanna_info]

Thanks for your  prompt response.but can u tell me how it works in qliksense?