Create a flag and color cell accordingly

[BhaminiParmar12]

The below is my data in this I want to create a flag 

Num	Name	PRAG	CRAG	Value
1	ksfhwef	G	R	183
2	weifjo	R	A	600
3	weoifkwenm	R	G	174
4	wef	A	G	477
5	pocijepw	G	R	106
6	okjprrg	G	R	189
7	eproijgp	R	A	410
8	erpioj	R	G	546
9	wepoj	A	G	315
10	we	G	G	420
11	dmk2f	R	R	686
12	fvdkjvpeioj	R	G	684
13	jkbxc u	A	G	444
14	dfivjeproj	R	R	537
15	lkdmvor	R	R	143
16	rewgre	R	G	271
17	epirjf	G	G	385
18	erge	G	R	685
19	lkndvoi	R	R	431
20	mvb	R	G	426
21	vlkernlk	R	R	682
22	ervmer	A	R	454
23	qefmkpap	G	A	271
24	kjsendwqed	G	G	624
25	ekwmdoi	R	G	614

I need to create a flag 

CRAG	Direction
R	Neutral
G	Up
A	Up
G	Up
R	Down
A	Neutral
A	Down
R	Down
G	Neutral

I want the output like this 

[Rohan]

Hi @BhaminiParmar12 ,

Please elaborate as to how you are generating that Direction, Is it based on the Previous Month's value or what ? You need to properly explain your problem so that people with similar issues can guide you.

Regards,

Rohan.

[BhaminiParmar12]

Hi  @Rohan nothing like that i just want to create a flag Direction that when I load in my table then I want to color my value on base of CRAG for eg. if Direction is neutral then Red color in my table 

[Rohan]

Hi @BhaminiParmar12 ,

On what basis is that Direction defined ? Because your CARG value 'A' has multiple Occurance with different direction flag values. How are you defining that ?

Regards,

Rohan.

[pallavi_96]

Hi @BhaminiParmar12 

You can use the provided expression in the "Color Expression" option for each dimension in the table.

if(CRAG='R','#FF0000',
if(CRAG='G',Green(),yellow()))

if(CRAG='Red',Red(),GRAG='Green',Green()

[BhaminiParmar12]

Thanks @pallavi_96 

[pallavi_96]

Hi @BhaminiParmar12 ,

please accept the solution if its works for you.

[BhaminiParmar12]

Hi, @Rohan Direction is based on both month values but Color is based on Current Value 
so do you have any solution for Direction, please let me know. ThankYou.

[BhaminiParmar12]

Hi, @Rohan I want the Condition on this bases is mentioned below:
By using If Condition

PRAG	CRAG	Direction
R	R	Neutral
R	G	Up
R	A	Up
A	G	Up
A	R	Down
A	A	Neutral
G	A	Down
G	R	Down
G	G	Neutral

[Rohan]

Hi @BhaminiParmar12 ,

The Logic that i could make out is something like : 

DirectionMap:

Mapping Load CRAG&'|'&PRAG as Key,

Flag ;

Load * Inline [

CRAG,PRAG,Flag

R,R,Neutral

R,A,Up

R,G,Up

A,R,Down

A,A,Neutral

A,G,Up

G,R,Down

G,A,Down

G,G,Neutral];

& then in your Data Table, Add :

Applymap('DirectionMap',CRAG&'|'&PRAG,'N/A') as Direction

Try this & let me know if this worked for you.

Regards,

Rohan.