Sort and get minimum name for the value

saumyashah90 — Tue, 24 Mar 2015 06:12:04 GMT

Here I want to get Name of prev page whose Sum(hits) is max and min

I tried using

=only({<prevpagename={"=rank(Sum(Hits))=1"}>}prevpagename) for max output-> EFG

=only({<prevpagename={"=rank(-Sum(Hits)=1"}>}prevpagename) for min no output

Here when we get minimum we have 2 values for prevpage whose sum(Hits) is minimum.. I want to get one .

Is there anyway to sort it and get the value

Remember i want to get this in Text box and not in straight table or pivot.

Basically it gets confused in what to take/ Is their any way if we can sort it and get the minimum one.Any way?

Re: Sort and get minimum name for the value

saumyashah90 — Tue, 24 Mar 2015 07:44:33 GMT

Any try?