{
  "sales": "aggregated sellout amount and sellin amount from mx_sales in crores",
  "Sales": "aggregated sellout amount and sellin amount from mx_sales in crores",
  
  "quantity":"total quantity from mx_sales table in thousands (k)",
   
  "volume":"total quantity from mx_sales table in thousands (k)",
   "North 1": "Region 'North 1'",
  "North 2": "Region 'North 2'",
  "North 3": "Region 'North 3'",
  "East 1": "Region 'East 1'",
  "East 2": "Region 'East 2'",
  "South 1": "Region 'South 1'",
  "South 2": "Region 'South 2'",
  "South 3": "Region 'South 3'",
  "West 1": "Region 'West 1'",
  "West 2": "Region 'West 2'",
  "West 3": "Region 'West 3'",
  "West 4": "Region 'West 4'",

  "North1": "Region 'North 1'",
  "North2": "Region 'North 2'",
  "North3": "Region 'North 3'",
  "East1": "Region 'East 1'",
  "East2": "Region 'East 2'",
  "South1": "Region 'South 1'",
  "South2": "Region 'South 2'",
  "South3": "Region 'South 3'",
  "West1": "Region 'West 1'",
  "West2": "Region 'West 2'",
  "West3": "Region 'West 3'",
  "West4": "Region 'West 4'",



"SAMSUNG":"Samsung",
"samsung":"Samsung",
  "North": "Region ('North 1','North 2','North 3')",
  "north": "Region ('North 1','North 2','North 3')",
    
  "East": "Region ('East 1','East 2')",
  "east": "Region ('East 1','East 2')",
    
  "MR":"MT",
    
  "South": "Region ('South 1','South 2','South 3')",
  "south": "Region ('South 1','South 2','South 3')",
    
  "West": "Region ('West 1','West 2','West 3','West 4')",
  "west": "Region ('West 1','West 2','West 3','West 4')",
    
  "Accessories" : "Segment 'Accessories'", 
  "Note Pc" : "Segment 'Note Pc'",
  "Smart Phone" : "Segment 'Smart Phone'", 
  "Tab" : "Segment 'Tab'",
  "Wearable" : "Segment 'Wearable'",
  "smart phone":"Segment 'Smart Phone'",
  "smartphone":"Segment 'Smart Phone'",
  "Smartphone":"Segment 'Smart Phone'",
  "SmartPhone":"Segment 'Smart Phone'",

    
    "B2B" :"Channel 'B2B'",
    "GT" :"Channel 'GT'",
    "MT" :"Channel 'MT'",
    "ON" :"Channel 'ON'",
    "ONLINE" :"Channel 'ONLINE'",
    "MR" :"Channel 'MR'",

    "6 to 10k": "priceband '6 K - 10 K'",
    "6-10k": "priceband '6 K - 10 K'",
    "6k-10k": "priceband '6 K - 10 K'",

    "10 to 15k": "priceband '10 K-15 K'",
    "10-15k": "priceband '10 K-15 K'",
    "10k-15k": "priceband '10 K-15 K'",

    "15 to 20k": "priceband '15 K-20 K'",
    "15-20k": "priceband '15 K-20 K'",
    "15k-20k": "priceband '15 K-20 K'",

    "20 to 30k": "priceband '20 K - 30 K'",
    "20-30k": "priceband '20 K - 30 K'",
    "20k-30k": "priceband '20 K - 30 K'",

    "30 to 40k": "priceband '30 K - 40 K'",
    "30-40k": "priceband '30 K - 40 K''",
    "30k-40k": "priceband '30 K - 40 K'",
    ">40k":"priceband 'Above 40K'",
    "greater than 40k":"priceband 'Above 40K'",

    "<6k":"priceband 'Below 6K'",
    "less than 6k":"priceband 'Below 6K'",
    "SO" : "aggregated sellout","realme":"Competitor Realme",

    "Realme":"Competitor Realme",
    "samsung":"Competitor Samsung",
    "Samsung":"Competitor Samsung",
    "oneplus":"Competitor Oneplus",
    "Oneplus":"Competitor Oneplus",
    "xiaomi" :"Competitor Xiaomi",
    "Xiaomi" :"Competitor Xiaomi",
    "apple" :"Competitor Apple",
    "Apple" :"Competitor Apple",
    "oppo" :"Competitor Oppo",
    "Oppo" :"Competitor Oppo",
    "vivo":"Competitor Vivo",
    "Vivo":"Competitor Vivo",
    
    "jan":"Month Jan ",
    "feb":"Month feb",
    "mar":"Month March",
    "apr":"Month april",
    "may":"Month May",
    "jun":"Month June",
    "jul":"Month July",
    "aug":"Month August",
    "sep":"Month September",
    "oct":"Month October",
    "nov":"Month November",
    "dec":"Month December",
    
    "2024": "Year 2024",
    
    "this year Diwali":"5th Nov 2023 to 9th Nov 2023",
    "last year diwali": "22nd Oct 2022 to 26th Oct 2022",
    
   
    "models":"modelnames",
    "Model":"modelname",
    "model":"modelname",
    "Modelcode":"modelname",
    "modelcode":"modelname",
    "sales contribution":"Percentage aggregated sellout_amount contribution" ,   
    "s24":"familyname S24",
    "S24":"familyname S24",
    "s23":"familyname S23",
    "S23":"familyname S23",
    "monthly":"for each month",
    "units":"quantity",
    "unit":"quantity",
    "Q1":"Month (April,May,June)",
    "q1":"Month (April,May,June)",
    "Q2":"Month (July,August,September)",
    "q2":"Month (July,August,September)",
    "Q3":"Month (October,November,December)",
    "q3":"Month (October,November,December)",
    "Q4":"Month (Jan,Feb,March)",
    "q4":"Month (Jan,Feb,March)",
    "Quarter 1":"Month (April,May,June)",
    "quarter 1":"Month (April,May,June)",
    "Quarter 2":"Month (July,August,September)",
    "quarter 2":"Month (July,August,September)",
    "Quarter 3":"Month (October,November,December)",
    "quarter 3":"Month (October,November,December)",
    "Quarter 4":"Month (Jan,Feb,March)",
    "quarter 4":"Month (Jan,Feb,March)",
    "brand":"Competitor from mx_dlb"
    
}


this is the glossary,when user type sales for north 1 ,then sales for Region (north 1 ,north 2,north 3) 1 is getting done,but i need sales for north 1