Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

previous 2 years average and show the data

Hi All, Need help in solving the below . Need to calculate the average of previous year month . Eg:   Date                           Regular Time 1/1/2017 0:00            55352.36 2/1/2017 0:00...
Need Help
  • moumipanja's avatar
    moumipanja
    7 years ago

    You can use a matrix format to get the desired output. Use Date in Rows and keep only Month in the hierarchy. Use Regular Time in Values and then select Average in the Values field..

     

     

    you will get your output.

moumipanja's avatar
moumipanja
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

You can use a matrix format to get the desired output. Use Date in Rows and keep only Month in the hierarchy. Use Regular Time in Values and then select Average in the Values field..

 

 

you will get your output.