Geo-Powered Retail Intelligence with Zoho Analytics

In today’s highly competitive retail landscape, data-driven decisions are no longer optional — they’re essential. While businesses collect vast volumes of data across regions, stores, and customer segments, the real value lies in how effectively this data is visualized and interpreted.

Geo Maps in Zoho Analytics bring location intelligence to the forefront of decision-making. With powerful spatial analytics capabilities, retail businesses can now visualize store performance, identify untapped opportunities, and track customer behavior trends with a simple glance at a map.

This solution demonstrates how Zoho Analytics' Geo Maps can be leveraged to solve real retail business problems, using a step-by-step approach grounded in a practical, ready-to-use dataset.

• Business scenario
• Dataset Overview
• Problem Description
• Why Geo Maps Become a Game-Changer
• Solution Implementation – Report Creation
• Store Performance Analysis (Map – Bubble)
• Revenue-to-Traffic Ratio with Ghost Zone Detection (Map - Filled + Scatter)
• Competitor Pressure Zones (Map – Scatter)
• Customer Gender Distribution (Map - Pie)
• Summary

Business scenario

Imagine you're a retail chain operating hundreds of stores across the United States. Each store generates data—sales, visitor footfall, customer satisfaction, marketing spend—but these numbers alone don’t explain why some stores succeed while others under-perform.

Key challenges include:

• Identifying stores that are struggling before sales drop significantly.
  
• Understanding whether poor performance is due to location, low visibility, or intense competition.
  
• Evaluating which regions offer true expansion potential—and which are over-saturated.
  

With no visual correlation between location and business KPIs, many decisions remain reactive instead of proactive. This is where Geo Maps make all the difference—by transforming isolated data into contextual geographic insights.

Dataset Overview

To power this solution, we’ve created a comprehensive and realistic retail dataset that mirrors how actual store data behaves across geographies.

The dataset includes:

• Store-level performance data: revenue, average purchase value, and satisfaction.
  
• Customer insights: foot traffic, age, gender distribution.
  
• Market context: competitor presence and market share, population density, and economic growth rate.
  
• Geospatial data: zip code, city, state, latitude, and longitude of each store location.
  
  

Problem Description

Retail chains often operate on thin margins, and even minor under-performance at store level can have significant impacts across the organization. While dashboards provide revenue and performance trends, they often miss one critical dimension—geography.

Without geographic context, businesses face several recurring challenges:

• Underperforming stores go unnoticed until major losses occur.
  
• Ghost zones—areas with low store presence but high potential—remain unexplored.
  
• Marketing budgets get wasted in regions where returns are consistently low.
  
• Competitor pressure is misjudged due to lack of visibility on regional saturation.
  
• Store closures become reactive decisions, made after performance has already declined.
  

In short, data without location awareness leaves decision-makers blind to spatial trends and risks. Businesses need a smarter, more intuitive way to analyze store performance with geographical clarity—before it’s too late.

Why Geo Maps Become a Game-Changer

Geo Maps in Zoho Analytics address this gap by unlocking a visual layer of intelligence that traditional charts can’t offer.

Here’s what makes them a game-changer:

• Location-first insights: Instantly identify how store performance varies across the map - by city, state, or neighborhood.
  
• Visual correlation of multiple KPIs: Compare revenue, satisfaction, and foot traffic geographically to detect hidden patterns.
  
• Clutter-free, customizable visuals: Choose the right map type - bubble, filled, pie, or scatter - to match the data you want to analyze.
  

Unlike static dashboards, Geo Maps enable you to see the problem, context, and opportunity—all in one frame. Whether it's spotting trends, reallocating marketing spend, or planning expansion, this spatial layer puts decision-makers back in control.

Solution Implementation – Report Creation

This section walks through the step-by-step creation of four key Geo Map reports that reveal business insights from store-level data.

1. Store Performance Analysis (Map – Bubble)

To identify how stores are performing across different regions in terms of revenue and customer satisfaction, using a clean, visual-first map representation.

This helps uncover:

• High-performing stores in key zones
  
• Underperforming regions needing intervention
  
• Patterns related to location-based store success
  

Why Map - Bubble?

The Map - Bubble chart is ideal for visualizing store-level metrics using geolocation.

• Size indicates magnitude (e.g., Monthly Revenue)
  
• Color indicates health or quality (e.g., Customer Satisfaction)
  
• Each store appears as a distinct bubble based on its lat/long.
  

Procedure

1. From the dataset, click the Create icon and select Chart View.
   
   
2. On the designer page, drag and drop the following columns into their respective shelves:
1. Latitude → X-Axis
2. Longitude → Y-Axis
3. Customer Satisfaction (out of 10) → Color
4. Monthly Revenue (USD) → Size
5. Store ID, Store Type, City → Tooltip
   
   
3. Click Generate Graph.
4. Click on the ellipsis icon and select the chart type as Map - Bubble.
   
   
5. Click the Settings icon, and under the General tab, click Legend.
6. In the Colors section, customize the color scale from red to green to represent satisfaction ranges.
   
   
7. Under the Map tab, click Map control and enable Display Specific Country Map.
   
8. From the drop-down, select Albers USA Projection. This displays the USA map by placing Alaska and Hawaii below the mainland USA on a single map.
   
   
9. Rename the report as Store Performance and click Save.
   

Tip:

Add a User filter such as Store type or State to analyze performance by segment.

This configuration creates a bubble for every store, sized by its revenue and colored by customer satisfaction — instantly showing how happy customers are in high- or low-revenue zones.

Key Insights

Large bubble + Red color - High revenue but poor satisfaction — risk of churn!

Small bubble + Green color - Low revenue but high satisfaction — possibly underserved

Large bubble + Green color - Healthy performers — consider replicating success

Small bubble + Red color - Low performers — review for possible closure or revamp.

Business Interpretation

This chart acts as a live performance map for executives and analysts. Instead of scanning through tables or KPIs, stakeholders can instantly spot outliers, prioritize investments, and plan corrective actions by just glancing at the map.

2. Revenue-to-Traffic Ratio with Ghost Zone Detection (Map - Filled + Scatter)

To evaluate how efficiently each state is converting foot traffic into store revenue — and more importantly, to identify high-footfall regions without store presence, often referred to as ghost zones.

This chart helps:

• Compare state-level foot traffic against actual revenue
  
• Spot underutilized or over-performing regions
  
• Discover untapped markets with high visitor potential but less to no physical stores
  

Why Map - Filled + Scatter?

• The Map - Filled chart provides a regional perspective of traffic density and revenue generation.
  
• The Scatter layer overlays actual store locations based on latitude and longitude.
  

This powerful combo allows you to measure performance where you’re active and spot opportunities where you're not.

Procedure

1. From the dataset, click the Create icon and select Chart View.
   
2. On the designer page, drag and drop the following columns into their respective shelves:
   
1. State → X-Axis
   
2. Foot Traffic (visitors/month) → Color
   
3. Monthly Revenue (USD) → Text
   
4. Marketing Spend (USD), Population Density (people/sq km), ROI (%) → Tooltip
   
3. Click Generate Graph.
   
   
4. Click on more option and select the chart type as Map-Filled.
   
   
5. Click the Settings icon, then click Legend.
   
6. In the Colors section, assign from light to dark green colors for the below range of foot traffic:
   
1. Below 5,000
   
2. 5,000–10,000
   
3. 10,000–15,000
   
4. Above 15,000
   
   
7. Under the Map tab, change the map to Albers USA Projection.
   This filled layer highlights traffic and revenue across states.
   
   
8. Toggle Enable Layers to add a second layer.
   
   
9. In the new layer, drag and drop Latitude and Longitude into the X-Axis and Y-Axis respectively, Population density into the Color shelf, and click Generate Graph.
   
   
10. Click Layer Controls, select Chart Chooser besides Latitude and choose the map as Map - Scatter from the list.
    
    
11. To customize the second layer, go to Settings → Map → Latitude → Legend, and assign from light to dark red colors for the below range of population density:
    
1. Below 2,000
   
2. 2,000-4,000
   
3. 4,000-6,000
   
4. 6,000-8,000
   
5. 8,000-10000
   
6. Above 10,000
   
   
12. Rename the report as Revenue-to-Traffic Ratio with Ghost Zone Detection and click Save.
    

This scatter layer marks the exact store locations, allowing visual correlation with high-traffic regions, revenue, and population density.

Key Insights

Dark green filled (high traffic) + Low revenue - Poor conversion - evaluate strategy or in-store experience

Mid to Dark green filled (high to mid traffic) + balanced revenue - Efficient zones — consider scaling efforts

Light green filled (low traffic) + high marketing spend (from tooltip) - Budget drain — reduce spend or re-evaluate targeting

Dark red marker (high population density) + less to no store markers - Ghost Zones — high opportunity areas for expansion

Example: In Las Vegas from Nevada, with a population density of 10,428 people/sq km and only two stores handling 10K–15K visitors/month, monthly revenue of the state remains modest at ~$278K. This indicates a high-opportunity zone for expansion, with strong footfall but untapped revenue potential.

Interpretation & Use

This map is designed for marketing and expansion teams who need to:

• Justify where to open new stores
  
• Optimize existing resource allocation
  

It visually answers the question:

Are we generating revenue where people are actually showing up?

Also, with the scatter layer:

Where are we not present — but should be?

​

3. Competitor Pressure Zones (Map – Scatter)

To evaluate how store performance is impacted by nearby competition, using a scatter map that plots every store across the U.S. and reflects competitor market share through color intensity.

This view helps:

• Detect locations under competitive stress
  
• Identify high-risk zones where your market share is at risk
  
• Correlate competitor presence with satisfaction and store performance
  

Why Map - Scatter?

Map - Scatter offers a clean and lightweight visual that plots each store based on its exact coordinates. By encoding competitor market share as color and overlaying other attributes via tooltip, this chart becomes a competitive pressure radar.

Procedure

1. From the dataset, click the Create icon and select Chart View.
   
2. In the chart designer, drag and drop the following columns into their respective shelves:
   
1. Latitude → X-Axis
   
2. Longitude → Y-Axis
   
3. Competitors market share → Color
   
4. Competitors nearby, Monthly Revenue, and Store Type → Tooltip
   
3. Click Generate Graph.
   
   
4. Click on the more option and select the chart type as Map-Scatter.
   
5. In the Settings panel, adjust the color gradient to reflect pressure levels
   
1. 0 → Green
   
2. 1-30 → Cyan
   
3. 30-60 → Orange
   
4. 60-80 → Pale red
   
5. Above 80 → Red
   
   
6. Change the Marker type under Maps → Marker tab.
   
   
7. Under the Map tab, change the map to Albers USA Projection.
   
8. Rename the report as Competitor Pressure Zones and click Save.
   

The resulting chart uses color to signal competitive heat around each store, allowing you to scan pressure zones across all regions visually.

Key Insights

Red (80-100%) - High competitor dominance — urgent intervention zone

Orange (30-60%) + low revenue - Growing pressure — performance risk emerging

Green (0%) + strong revenue - Market leader — low competition, strong position

Cyan (1-30%) + moderate revenue - Mild competition — possible opportunity to scale further

Business Interpretation

This chart empowers regional and strategy teams to:

• Detect overcrowded areas where stores are losing share
  
• Identify safe zones where your brand leads the market
  
• Spot emerging competitor influence before it cuts into your margins
  

It acts as a competitive intelligence dashboard, mapping how your store network stands against external threats.

​

4. Customer Gender Distribution (Map - Pie)

To visualize how the gender distribution of customers varies across store locations. This helps identify stores with significant demographic skews, allowing for more personalized marketing, product selection, and in-store experience.

Why Map - Pie?

The Map - Pie chart is ideal for visualizing data composition across geographical locations.By breaking down each store’s customer base into Male (%) and Female (%) segments, this chart reveals who your customers are and where gender-targeted strategies might work best.

Procedure

1. From the dataset, click the Create icon and select Chart View.
   
2. In the chart designer, drag and drop the following columns into their respective shelves:
   
1. Latitude → X-Axis
   
2. Longitude, Male (%), Female (%) → Y-Axis
   
3. City, Store ID, Average Customer Age, Store Type → Tooltip
   
3. Click Generate Graph.
   
   
4. In Settings, under the Map tab, change the map to Albers USA Projection.
   
5. Click on Markers, adjust the Marker Size as shown.
   
   
6. Click on Data Label, and enable the Show corresponding Y axis value as data label on the chart to display the percentage values on the map.
   
   
7. Add Store Type as User Filters to slice down store-wise gender distribution.
   
8. Rename the report as Customer Gender Distribution and click Save.
   

Each store will now display a pie chart representing the gender split among its customers, directly on the map.

Key Insights

Uneven gender split (e.g., 70% Male) - Potential to tailor offerings, branding, or promotions for the dominant gender

Balanced split (≈50/50) - Opportunity to run inclusive or diversified campaigns

High female ratio + specialty store - Indicates demand for niche products — expand category offerings

Business Interpretation

This chart allows marketing and merchandising teams to:

• Understand gender-based customer clustering across regions
  
• Launch targeted campaigns (e.g., loyalty programs, promotions)
  
• Refine product assortments to suit local preferences
  

For example: A store with 70% female shoppers may benefit from deeper investment in lifestyle categories, while a balanced store could serve as a testing ground for unisex offerings.

​

Summary

In this phase, we laid the foundation for geo-powered retail intelligence using Zoho Analytics. Through a single, well-structured dataset and four powerful geo map visualizations, we transformed raw store data into real, actionable business insights.

Here’s what we achieved:

Report	Business Insights
Store Performance (Bubble)	Identified stores that are over performing or at churn risk based on revenue and satisfaction.
Revenue-to-Traffic Ratio (Filled + Scatter)	Detected ghost zones and optimized marketing ROI by comparing traffic and revenue.
Competitor Pressure Zones (Scatter)	Mapped out competitor dominance and spotted at-risk or saturated regions.
Customer Gender Distribution (Pie)	Uncovered demographic patterns to tailor product, marketing, and in-store experience.

Click here to access the sample workspace.

These visualizations brought spatial awareness into every performance metric — turning maps into a strategic business tool.

And this... is just the beginning.

Stay tuned for Phase 2 — where Multi-Layer Geo Maps and Network Charts come together to supercharge your business strategy with even deeper spatial insights.

• Topic Participants

• Pradeepkumar R

  

• Sticky Posts

• What’s New in Zoho Analytics – September 2025

  Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

• Announcing Agentic AI - Ask Zia!

  We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

• Invitation-Based User Access in Zoho Analytics

  Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

• Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

  Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you

• [Webinar] Evolving BI & Analytics in the Age of AI

  Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations

• Recent Topics

• How can I calculate the physical stock available for sale?

  Hey Zoho Team,  I've tried to calculate the physical stock on hand in various ways - but always receive a mismatch between what's displayed in Zoho Inventory & analytics.  Can you please let me know how the physical stock available for sale is calculated?

• When dispatched to crew, assigning lead missing

  Hello, For the past two or three weeks, whenever an officer assigns Service Appointment to a team, the lead person is missing from the assigned service list. Therefore, we have to reschedule the SA and then the lead person becomes visible in the assigned

• open word file in zoho writer desktop version

  "How can I open a Microsoft Word (.doc or .docx) file in Zoho Writer if I only have the file saved on my computer and Zoho Writer doesn't appear as an option when I try 'Open with'? Is there a way to directly open the .doc file in Zoho Writer?"

• I want to transfer the project created in this account to another account

  Dear Sir I want to transfer the project created in one account to another account

• Inactive User Auto Response

  We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similar

• Weekly Tips : Customize your Compose for a smoother workflow

  You are someone who sends a lot of emails, but half the sections in the composer just get in your way — like fields you never use or sections that clutter the space. You find yourself always hunting for the same few formatting tools, and the layout just

• Zoho Slowness - Workarounds

  Hi all, We've been having intermittent slowness and Zoho just asks for same stuff each time but never fix it. It usually just goes away on it's own after a couple weeks. Given that speed is a very important thing for companies to be able to keep up with

• Custom Bulk Select Button

  Zoho CRM offers the ability to select multiple records and invoke a Custom Button This functionality is missing from Recruit Currently we can only add buttons in the detail page and list But we cannot select Multiple Records and invoke a function with

• Zoho CRM still doesn't let you manage timezones (yearly reminder)

  This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet me

• Power of Automation :: Smart Ticket Management Between Zoho Desk and Projects

  Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate

• First day of trying FSM in the field.

  What we found. 1. with out a network connection we were unable to start a service call? 2. if you go to an appointment and then want to add an asset it does not seem possible. 3. disappointed not to be able to actually take a payment from within the app

• BUG - Google Business Buttons - Add a button to GBP Post

  I am experiencing an issue with the "Add a button" feature when creating posts for my Google Business Profile (GBP) through Zoho Social. When I schedule or publish a GBP post and include a call-to-action button with a specific URL, the post itself publishes

• Rich text Merge field - Not using font specified in HTML

  I have a rich text merge field in a writer template which is creating a table. I have chosen to use this method instead of a repeat region because I need to specify specific cell background colours which change every time the document is created. The

• Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

  Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these

• CC and/or BCC users in email templates

  I would like the ability to automatically assign a CC and BCC "User (company employee)" into email templates. Specifically, I would like to be able to add the "User who owns the client" as a CC automatically on any interview scheduled or candidate submitted

• Trying to export a report to Excel via a deluge script

  I have this code from other posts but it gives me an error of improper statement, due to missing ; at end of line or incomplete expression. Tried lots of variations to no avail. openUrl(https://creatorapp.zoho.com/<username>/<app name>/XLSX/#Report:<reportname>,"same

• Need help to create a attach file api

  https://www.zoho.com/crm/developer/docs/api/v8/upload-attachment.html Please help me to create it... It's not working for while. Do you have some example?

• Export view via deluge.

  Hi, Is it possible to export a view (as a spreadsheet) via deluge? I would like to be able to export a view as a spreadsheet when a user clicks a button. Thanks     

• Outdated state in mexico

  Hello Zoho team, the drop down to add the state for customers, when they introduce their state in mexico has a city named “Distrito Federal” that name changed many years ago to “ciudad de mexico”. could you please update this so my clients can find the

• Possible to generate/download Quote PDF using REST API?

  See title. Is there any way after a quote has been created to export to a PDF using a specified template and then download it? Seems like something that should be doable. Is this not supported in the API v2.0?

• Creating an invoice to be paid in two installments?

  Hi there, I own a small Photographic Services business and have not been able to find a way to fit my billing system into Zoho, or any other Accounting software. The way my payments work is: 1. Customer pays 50% of total price of service to secure their

• Bug in allowing the user to buy out of stock items

  Hi i want to allow the user to buy out of stock items, according to the commerce documentation if i disable Restrict "Out of stock" purchases it will, but it doesnt work, so i want to know if it had any relation with zoho inventory, and if theres any

• Replace Lookup fields ID value with their actual name and adding inormation from subforms

  Hi everyone,  I wanted to see if someone smarter than me has managed to find any solutions to two problems we have. I will explain both below.  To start we are syncing data from Zoho CRM to Zoho Analytics and I will use the Sales Order module when giving

• Can a Zoho Sites page be embedded into another website (outside Zoho)

  Hi All, We have a request from a client - they'd like to take one of our information pages created in Zoho Sites and embed it into their own website? I was told through an email with Zoho that this was possible >>Thank you for your patience regarding

• Bug in allowing the user to buy out of stock items

  Hi i want to allow the user to buy out of stock items, according to the commerce documentation if i disable Restrict "Out of stock" purchases it will, but it doesnt work, so i want to know if it had any relation with zoho inventory, and if theres any

• Transition Criteria Appearing on Blueprint Transitions

  On Monday, Sept. 8th, the Transition criteria started appearing on our Blueprints when users hover over a Transition button. See image. We contacted Zoho support because it's confusing our users (there's really no reason for them to see it), but we haven't

• Zoho CRM Sales Targets for Individual Salespeople

  Our organistion has salespeople that are allocated to different regions and have different annual sales targets as a result. I am building an CRM analytics dashboard for the sales team, which will display a target meter for the logged in salesperson.

• Transfer all Related Data to new Account Owner

  Currently when I change the account Owner I only see the option to change only the open deals But I want the new account owner to take over all the related modules and all the deal stages Is it not possible right now? Am I missing something? Do I really

• Can i connect 2 instagram accounts to 1 brand?

  Can i connect 2 instagram accounts to 1 brand? Or Do i need to create 2 brands for that? also under what subscription package will this apply?

• How to Calculate MTTR (Mean Time to Resolve)

  We want to calculate MTTR (Mean Time to Resolve) in our Zoho Analytics report under Tickets. Currently, we are using the following fields: Ticket ID Ticket Created Time Ticket Closed Time Ticket On Hold Time We are planning to calculate MTTR (in days)

• How to export project tasks, including the comments

  Hi, how can I export the project tasks, whereby I can also see the comments associated to a specific task? The use-case is that often we use comments to discuss or update a task related ideas. I would like to export the tasks, where we can also see the

• Does Zoho Sheet Supports https://n8n.io ?

  Does Zoho Sheet Supports https://n8n.io ? If not, can we take this as an idea and deploy in future please? Thanks

• Bigin Android app update: User management

  Hello everyone! In the most recent Bigin Android app update, we have brought in support for the 'Users and Controls' section. You can now manage the users in your organization within the mobile app. There are three tabs in the 'Users and Controls' section:

• Share records with your customers and let them track their statuses in real time.

  Greetings, I hope everyone is doing well! We're excited to introduce the external sharing feature for pipeline records. This new enhancement enables you to share pipeline records with your customers via a shareable link and thereby track the status of

• Live webinar: Discover Zoho Show: A complete walkthrough

  Hello everyone, We’re excited to invite you to our upcoming live webinar, Discover Zoho Show: A Complete Walkthrough. Whether you’re just getting started with Show or eager to explore advanced capabilities, this session will show you useful tips and features

• Deal Stage component/widget/whatever it is... event

  Deal Stages I am trying to access the event and value of this component. I can do it by changing the Stage field but users can also change a Deal Stage via this component and I need to be able to capture both values. Clicking on 'Verbal' for instance,

• Create advanced slideshows with hybrid reports using Zoho Projects Plus

  Are your quarterly meetings coming up? It’s time to pull up metrics, generate reports, and juggle between slides yet again. While this may be easier for smaller projects, large organizations that run multiple projects may experience the pressure when

• Add an option to disable ZIA suggestions

  Currently, ZIA in Zoho Inventory automatically provides suggestions, such as sending order confirmation emails. However, there is no way to disable this feature. In our case, orders are automatically created by customers, and we’ve built a custom workflow

• Email Integration - Zoho CRM - OAuth and IMAP

  Hello, We are attempting to integrate our Microsoft 365 email with Zoho CRM. We are using the documentation at Email Configuration for IMAP and POP3 (zoho.com) We use Microsoft 365 and per their recommendations (and requirements) for secure email we have

• Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function

  Hello there, I am working on a formula field based on a 3-item picklist field (i.e. *empty value*, 'Progress payment', 'Letter of credit'). Depending on the picked item, the formula field shall give a specific multi-line string (say 'XXX' in case of 'Progress

• Next Page