Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I get the ranking value from a pivot table to text object, to understand better the my problem I have attached a qvw file .
Could someone please help me on this.
Thanks in advance,
CAFC
Try:
=max(if(aggr(sum(Value),ARTICLE) = $(vT), aggr(rank(sum(Value)),ARTICLE)))
Try:
=max(if(aggr(sum(Value),ARTICLE) = $(vT), aggr(rank(sum(Value)),ARTICLE)))
it works!!
thank u very much
cedric