Skip to Content
0
Former Member
Aug 07, 2015 at 05:54 PM

about For each context

12 Views

hello gurus..

here my requirement is ... i am taking objects as country,state,sales revenue in web intelligence..i drag & drop" yr,sales revenue"

but i want max state sales revenue instead of yrs sales revenue...so i have used for each formula { =max([sales revenue]) foreach([state]) }

now it gives max state sales revenue but i want that state name too....