Getting Ranking issue for Time based on Max position
In my Webi Report, I need to show the time when the position is maximum in a day of the month.
Here as shown in the screen for Largest Positive Position (LPP) I have added Ranking as Top 3 based on the position.
I am getting #Multivalue error when I use formula =[Time] ForEach ([*LPP]).
Where, [*LPP] =Max(RunningSum([Amounts];... [Day])) ForEach([Time];...) In ([Day]))
Any help is appreciated.