Hello Everyone, I am really new to Power Queries and Power Pivot, I have tried to look for a solution but no luck so far!
I am trying to create an average income by canvasser field in my pivot using the two values currently being summarised by the pivot. One column is sum of the income and other distant count of products, all I am trying to is income divided by count. I am not sure where i am going wrong.
I am sorry if this has been asked before, I could not find anything.
Thank you so much
Suraiya
I am trying to create an average income by canvasser field in my pivot using the two values currently being summarised by the pivot. One column is sum of the income and other distant count of products, all I am trying to is income divided by count. I am not sure where i am going wrong.
I am sorry if this has been asked before, I could not find anything.
Thank you so much
Suraiya