Postcode Sum from a range

Hi Ronan,

2 quick thoughts for you...

If this is a one-off reporting need, you could pull Primary Address Postcode and Ticket Count in a Pivot Table and then download that widget as CVS or Excel, and do some quick manipulation there ... even just highlighting the Ticket Count value across the postcodes you're interested in and seeing the sum preview in the status bar.

If you'd like to keep it Analytics, and I recommend you do if you have any need to do this again, then you might try a Text filter on postcode. For Southern Tasmania, an OR set of criteria that looks like:

• Starts with 70
• Starts with 71
• Starts with 720

Then for the Northern Tasmania count, a Text filter AND criteria set that looks something like

• Starts with 7
• Doesn't start with 70
• Doesn't start with 71
• Doesn't start with 720

You could either have separate widgets for these, using widget level filters. Or to have both values in the same widget use a formula like:

( [Total Ticket Count] , [Primary Address Postcode] )

And for one instance of the formula, filter Primary Address Postcode for Southern Tasmania. Then duplicate the value and edit the filter to reflect the criteria for Northern Tasmania.

Thanks Chris. That's worked beautifully

Thanks Chris. That's worked beautifully