Aggregating Data in Dashboard

Discussion created by aelbadawyka on Feb 2, 2014
Latest reply on Feb 4, 2014 by aelbadawyka

I have created an Excel sheet with the Sales information for our plots including the Sales Man and the selling price for each plot. I have already shared this excel sheet as a layer and created a webmap from it.

This webmap is embedded in my operations dashboard view. I need to create a widget that can show me total sales per sales man as an indicator on the dashboard. However am not able to, I tried using query which only does one selection and I cant do any further operation on the selection like summation.

Any thoughts on how this could be done,or do I have to it in arcgis online?