Forum Discussion
tomas12344
Helper III
2 years agocalculate average from aggregated values
HI All Custome want a report, where the average is calcualted from aggregated values not from detail values of the table. The report table contains some hierarchies, base on which the data should ...
tomas12344
Helper III
2 years agoHI amitchandak Anonymous
Thank you for the reply, but I'm not sure, that the results are correct. I have little bit experimented, and found out, that when I use two Summarize function, it will provide correct avg calcualtion.
Currently, I dont know, how to connect this together, into the first matrix table( I mean the first table in the picture and the third, which shows correct avg values, as the user wants).