Adding average as one more in the dataset

[sriniprad08]

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

[AngelosPachis · Accepted solution]

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