Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I'm struggle with my pivot table. Problem is like that. I have a detailed table with group , item and qty.
All i need to do is to get a max value but from a sum. I cannot find a proper way.
As you can see i tried to use function AGGR(NODISTINCT Max(Forecast),Group) , but when i do thet i got a maximum value but from a details table and i need to know what is the maximum sum. In case below i need to get
for group A records 1 and 2 = 90 as a result of Item 1
for group B records 3 and 4 = 500 as a resulit of item 4
Can you explain more your request?
What is your expectative for the results in last column
Hi Jacek,
maybe this
Max(TOTAL <Group> Aggr(Sum(Forecast),Group,Item))
Regards,
Antonio
Antonio ! This is what i was looking for.
Thank you very much !
Hello Jacek,
Can you close the thread if you got the answer marking Antonio's response.