Solved: Re: Need Help on Pivot Table - Qlik Community

jvishnuram · ‎2012-10-25

hi,

Need help on Pivot table, Please find the attachment,

Any Suggestions will be appriciated.

Regards.,

Vishnu

VJ

Gysbert_Wassenaar · ‎2012-10-25

try this: if(rank(aggr(Sum(LineSalesAmount),CategoryID,Year))=1,Green())

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2012-10-25

try this: if(rank(aggr(Sum(LineSalesAmount),CategoryID,Year))=1,Green())

talk is cheap, supply exceeds demand

MayilVahanan · ‎2012-10-25

Hi

Please check the attached file

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

jvishnuram · ‎2012-10-25

Thanx a Lot for ur help i got it

Regards.,

Vishnu

VJ

Report Inappropriate Content · ‎2012-10-25

Hi.

See the attached file... is that what you wanted?

Reggards,

Bruno