axmo: '1.0'
name: Intro Model
description: Country × Year P&L model with Cost and Profit series and basic price analysis
exportedAt: '2026-06-11T12:24:33.519Z'
dimensions:
  Geography:
    type: categorical
    layers:
      - Top_Geography
      - Region
      - Country
    tree:
      All_Geography:
        Europe:
          - Italy
          - France
          - Germany
        Asia:
          - Japan
          - Singapore
  Time:
    type: categorical
    layers:
      - Top_Time
      - Year
    tree:
      All_Time:
        - '2025'
        - '2026'
        - '2027'
        - '2028'
        - '2029'
series:
  Admin:
    type: input
    dimensions:
      - Geography
      - Time
  Admin Cost Per Unit:
    type: calculated
    formula: Admin / Quantity
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  Cost:
    type: input
    dimensions:
      - Geography
      - Time
  Profit:
    type: calculated
    formula: Revenue - Total Cost
    dimensions:
      - Geography
      - Time
  Profit Contribution, %:
    type: calculated
    formula: Profit / Profit[All_Geography]
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  Profit Per Unit:
    type: calculated
    formula: Profit / Quantity
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  Profit Rank:
    type: calculated
    formula: |-
      IF(DimLevel(Geography) = 3, RANK(Profit, Profit[Country/], DESC), 
        IF(DimLevel(Geography) = 2, RANK(Profit, Profit[Region/], DESC), 0) 
      )
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  PurchasePrice:
    type: calculated
    formula: Cost / Quantity
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  Quantity:
    type: input
    dimensions:
      - Geography
      - Time
  Revenue:
    type: input
    dimensions:
      - Geography
      - Time
  Revenue Contribution, %:
    type: calculated
    formula: Revenue / Revenue[All_Geography]
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  SellingPrice:
    type: calculated
    formula: Revenue / Quantity
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
  Total Cost:
    type: calculated
    formula: Cost + Admin
    dimensions:
      - Geography
      - Time
  Variable Profit Per Unit:
    type: calculated
    formula: SellingPrice - PurchasePrice
    dimensions:
      Geography:
        rollUp: FORMULA
      Time:
        rollUp: FORMULA
dataSources:
  DemoData:
    sourceType: excel-range
    rangeRef: DemoData!A1:F26
    hasHeaders: true
    shape: table
dataLoaders:
  Load Admin:
    type: seriesLoader
    source: DemoData
    target: Admin
    loadMode: table
    valueColumn: Admin
    duplicateHandling: FIRST
    dimensionMappings:
      Geography:
        column: Country
      Time:
        column: Year
  Load Cost:
    type: seriesLoader
    source: DemoData
    target: Cost
    loadMode: table
    valueColumn: Cost
    duplicateHandling: FIRST
    dimensionMappings:
      Geography:
        column: Country
      Time:
        column: Year
  Load Quantity:
    type: seriesLoader
    source: DemoData
    target: Quantity
    loadMode: table
    valueColumn: Quantity
    duplicateHandling: FIRST
    dimensionMappings:
      Geography:
        column: Country
      Time:
        column: Year
  Load Revenue:
    type: seriesLoader
    source: DemoData
    target: Revenue
    loadMode: table
    valueColumn: Revenue
    duplicateHandling: FIRST
    dimensionMappings:
      Geography:
        column: Country
      Time:
        column: Year
axisDefinitions:
  Country:
    blocks:
      - dimension: Geography/Region
      - dimension: Geography/Country
      - dimension: Geography/Top_Geography
  Time × Series:
    blocks:
      - dimension: Time/Year
      - dimension: Time/Top_Time
      - series: Revenue
        format: '#,##0'
        newLine: true
      - series: Revenue Contribution, %
        format: 0%
      - series: Cost
        format: '#,##0'
      - series: Admin
        format: '#,##0'
      - series: Total Cost
        format: '#,##0'
      - series: Profit
        format: '#,##0'
      - series: Profit Contribution, %
        format: 0%
      - series: Profit Rank
        format: '0'
outputRanges:
  P&L Report:
    cell: '''P&L''!A1'
    rowDef:
      blocks:
        - axisDef: Time × Series
    colDef:
      blocks:
        - axisDef: Country
  Profit Report:
    cell: '''Price Analysis''!A1'
    rowDef:
      blocks:
        - dimension: Time/Year
        - dimension: Time/Top_Time
        - series: SellingPrice
          format: '0.0'
          newLine: true
        - series: PurchasePrice
          format: '0.0'
        - series: Variable Profit Per Unit
          format: '0.0'
        - series: Admin Cost Per Unit
          format: '0.0'
        - series: Profit Per Unit
          format: '0.0'
    colDef:
      blocks:
        - axisDef: Country
  Profit Report by Type:
    cell: '''Price Analysis-2''!A1'
    rowDef:
      blocks:
        - series: SellingPrice
          format: '0.0'
        - series: PurchasePrice
          format: '0.0'
        - series: Variable Profit Per Unit
          format: '0.0'
        - series: Admin Cost Per Unit
          format: '0.0'
        - series: Profit Per Unit
          format: '0.0'
        - dimension: Time/Year
          newLine: true
        - dimension: Time/Top_Time
    colDef:
      blocks:
        - axisDef: Country
data:
  DemoData!A1:F26:
    values:
      - - Country
        - Year
        - Quantity
        - Revenue
        - Cost
        - Admin
      - - Italy
        - 2025
        - 87
        - 1000
        - 600
        - 120
      - - Italy
        - 2026
        - 85
        - 1100
        - 650
        - 130
      - - Italy
        - 2027
        - 91
        - 1200
        - 700
        - 120
      - - Italy
        - 2028
        - 114
        - 1300
        - 750
        - 120
      - - Italy
        - 2029
        - 114
        - 1400
        - 800
        - 160
      - - France
        - 2025
        - 59
        - 800
        - 480
        - 70
      - - France
        - 2026
        - 63
        - 850
        - 510
        - 100
      - - France
        - 2027
        - 65
        - 900
        - 540
        - 110
      - - France
        - 2028
        - 76
        - 950
        - 570
        - 90
      - - France
        - 2029
        - 82
        - 1000
        - 600
        - 120
      - - Germany
        - 2025
        - 99
        - 1200
        - 720
        - 140
      - - Germany
        - 2026
        - 100
        - 1250
        - 750
        - 120
      - - Germany
        - 2027
        - 112
        - 1300
        - 780
        - 140
      - - Germany
        - 2028
        - 107
        - 1350
        - 810
        - 130
      - - Germany
        - 2029
        - 112
        - 1400
        - 840
        - 150
      - - Japan
        - 2025
        - 69
        - 950
        - 570
        - 110
      - - Japan
        - 2026
        - 82
        - 1000
        - 600
        - 90
      - - Japan
        - 2027
        - 83
        - 1050
        - 630
        - 100
      - - Japan
        - 2028
        - 98
        - 1100
        - 660
        - 110
      - - Japan
        - 2029
        - 101
        - 1150
        - 690
        - 130
      - - Singapore
        - 2025
        - 51
        - 700
        - 420
        - 70
      - - Singapore
        - 2026
        - 56
        - 750
        - 450
        - 80
      - - Singapore
        - 2027
        - 63
        - 800
        - 480
        - 90
      - - Singapore
        - 2028
        - 69
        - 850
        - 510
        - 80
      - - Singapore
        - 2029
        - 67
        - 900
        - 540
        - 100