3pt
4.5pt
57.75pt
463.5pt
MaxRowCount
100000
MaxColumnCount
20
RevenueDataset
96.75pt
105.75pt
116.25pt
144.75pt
19.24215pt
0in
0in
19.24215pt
96.75pt
true
true
Year
1
1
0in
0in
19.24215pt
105.75pt
true
true
Revenue
1
1
0in
0in
19.24215pt
116.25pt
true
true
Expense
1
1
0in
0in
19.24215pt
144.75pt
true
true
Profit
1
1
19.24215pt
0in
0in
19.24215pt
96.75pt
true
true
=Fields!Year.Value
1
1
0in
0in
19.24215pt
105.75pt
true
true
=Fields!Revenue.Value
1
1
0in
0in
19.24215pt
116.25pt
true
true
=Fields!Expenses.Value
1
1
0in
0in
19.24215pt
144.75pt
true
true
=Fields!Revenue.Value - Fields!Expenses.Value
1
1
19.26562pt
0in
0in
19.26562pt
96.75pt
true
true
YOY Change
1
1
0in
0in
19.26562pt
105.75pt
true
true
=(RunningValue(IIF(Max(Fields!Year.Value) == Fields!Year.Value,Fields!Revenue.Value,0),Sum,"RevenueDataset")/RunningValue(IIF((Max(Fields!Year.Value) - 1) == Fields!Year.Value,Fields!Revenue.Value,0),Sum,"RevenueDataset")) - 1
1
1
0in
0in
19.26562pt
116.25pt
true
true
=(RunningValue(IIF(Max(Fields!Year.Value) == Fields!Year.Value,Fields!Expenses.Value,0),Sum,"RevenueDataset")/RunningValue(IIF((Max(Fields!Year.Value) - 1) == Fields!Year.Value,Fields!Expenses.Value,0),Sum,"RevenueDataset")) - 1
1
1
0in
0in
19.26562pt
144.75pt
true
true
=(RunningValue(IIF(Max(Fields!Year.Value) == Fields!Year.Value,Fields!Revenue.Value - Fields!Expenses.Value,0),Sum,"RevenueDataset")/RunningValue(IIF((Max(Fields!Year.Value) - 1) == Fields!Year.Value,Fields!Revenue.Value - Fields!Expenses.Value,0),Sum,"RevenueDataset")) - 1
1
1
After
Before
277.5pt
471pt
49.5pt
true
true
2.25pt
1.5pt
48pt
464.25pt
true
2.25pt
11.25pt
30pt
439.5pt
true
true
Year-Over-Year Comparison
0.72917in
true
true
1in
1in
1in
1in
0
JSON
{"Data":"{\n \"details\": [\n {\"Year\": 2023, \"Revenue\": 8753, \"Expenses\": 6500},\n {\"Year\": 2024, \"Revenue\": 9240, \"Expenses\": 8700}\n ]\n}\n","DataMode":"inline","URL":""}
false
Year
System.Double
Revenue
System.Double
Expenses
System.Double
RevenueDetails
Text
{"Name":"Result","Columns":[]}
4
2
Inch
Px
Segoe UI