In the first column is planned target time, in the second one real (aggregated from one to few rows), in the third percent of plan realization. When I choose "Average" for this column it calculates average value for each row, what I want is to preserve summarising in each row but show average of that in the table bottom. Is it possible?
Hi, thank you for your response. I hope this little model can help understand my problem.
Two tables at the top are my model. They contain raw data. Then we have three situations, the first one is what I want to achieve and both next are what I get when try to sum or average the data. The second situation, "What I got when summing" is almost good. Data in each row is perfect, however in the summarizing row I want to have average of all percents in column, not sum of them.