Answered

Report Customers by Postcode

A client has asked how to add postcode as a column in a standard BI4Cloud Sales by Customer report?

0

Comments

1 comment
Date Votes
  • Official comment

    The Customer Postcode (Zipcode) can be displayed in BI4Cloud Sales reports in a number of ways:

    1. Sub-total Customers by Postcode

    Simply choose to Group by the Customer Postcode field, this will group all customers together that share the same billing Postcode.

    2. Add Postcode as a new Column field against each Customer

    To show the Postcode as a new field that appears against each Customer use the Group by Type = Columns. 
    Click the Green + icon to access more advanced Group by Options including Multiple subtotals

    3. Analyse by Postcode to see Total sales for each Postcode as a row

    Analyse by Postcode to see Postcode as Rows, you could then add a Group by Customer State field too.

    4. See All Customers by Postcode 

    Suggest also use the BI4Cloud Customer Card List report which will report over ALL customers setup in your system, not just ones who you have recently sold to.

    See  Customer Card List - Who needs CRM?

     

     

Please sign in to leave a comment.

Didn't find what you were looking for?

New post