This content has been marked as final. Show 4 replies
I'm struggle with my pivot table. Problem is like that. I have a detailed table with group , item and qty.
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