0
0
Power BIbi_tool~10 mins

Decomposition tree in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by Region and Product Category with sales amounts.

CellValue
A1Region
B1Product Category
C1Sales
A2North
B2Bikes
C21000
A3North
B3Accessories
C3500
A4South
B4Bikes
C4700
A5South
B5Clothing
C5300
Formula Trace
SUM(Sales)
Step 1: SUM(C2:C5)
Cell Reference Map
   A       B           C
1 Region  Product Category   Sales
2 North   Bikes             1000
3 North   Accessories       500
4 South   Bikes             700
5 South   Clothing          300

Formula references cells C2 to C5 for Sales values.
The formula sums the Sales column values from C2 to C5.
Result
   A       B           C
1 Region  Product Category   Sales
2 North   Bikes             1000
3 North   Accessories       500
4 South   Bikes             700
5 South   Clothing          300

Total Sales: 2500
The total sales value 2500 is the sum of all sales in the table.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the total sales value calculated by the formula?
A2300
B2500
C2700
D2000
Key Result
SUM(column) adds all numeric values in the specified column.