Sales analysis Dashboard

Yahoo Archive
1

Check the table as summary in your baq and then use one of the aggregate functions max, sum, avg to display the result

On Mar 30, 2015 5:32 PM, "cantercf@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>I have the same question:Â  How do I summarize by a field within my BAQ?</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>
2
I have a dashboard to summarize sales. As options, the user can select a customer name, customer group and a date range. I've entered a summary for the extended price from the InvDtl table. In the dashboard view the user can see a summary (subtotal) by customer; or the total for all records selected. The user would like to be able to sort the data by the subtotal for each customer - highest to lowest. Is there a way to do that using a BAQ and dashboard?
3
Did you get help with this?

Sent from my iPhone

On Mar 13, 2013, at 9:52 AM, "stanchmura" <schmura@...<mailto:schmura@...>> wrote:



I have a dashboard to summarize sales. As options, the user can select a customer name, customer group and a date range. I've entered a summary for the extended price from the InvDtl table. In the dashboard view the user can see a summary (subtotal) by customer; or the total for all records selected. The user would like to be able to sort the data by the subtotal for each customer - highest to lowest. Is there a way to do that using a BAQ and dashboard?





[Non-text portions of this message have been removed]
4
I have the same question:  How do I summarize by a field within my BAQ?