Adding average as one more in the dataset

Question

Hi Team,

Hope you are well

I am calculating the average of all the months by ADS, RGF and year month. I would like to have one more row in the final datasets as the average.

Please find attached the input and desired output.

Please let me know is it possible.

thanks for the help

Sr

input_new.xlsx

output_new.xlsx

AngelosPachis · Accepted Answer

Hi @sriniprad08 ,

Yes you can use a summarize tool to average the full access % values per ADS, RGF and year month

and union that back to your main dataset

Hope that helps,

Angelos