Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Any try?