Weight v Revenue Week-On-Week - Revision history

Stanley.songok: /* Calculations */

2025-10-01T13:30:12Z

Calculations

← Older revision		Revision as of 15:30, 1 October 2025
Line 86:		Line 86:
	)</pre>		)</pre>
	\|		\|
			* '''Total Revenue in Euro''' – Calculates the total revenue by summing all values in Euro from the combined quotations table.

			* '''CHW (KG)''' – Calculates the total chargeable weight in kilograms, converting from Lb when needed.
			\|-
			\|2'''.Total Revenue by Week Numbers and Entity'''
			\|Total Revenue In euro =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
			\|This is a table that displays weekly Revenue in EUR and CHW(KG) across different entities.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-01T13:23:23Z

Calculations

@@ Line 67: / Line 67: @@
 !Description
 |-
+|1.'''Revenue and CHW(KG) by Week Number'''
+|Total Revenue In euro = <pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
+|
 |}

Stanley.songok: /* Data Transformation Applied */

2025-10-01T13:19:40Z

Data Transformation Applied

@@ Line 40: / Line 40: @@
 !Transformations
 |-
+|
+* '''Formatting''' – Data is arranged into a consistent structure used across all report pages.
 |}

Stanley.songok: /* Filters */

2025-10-01T13:18:28Z

Filters

@@ Line 9: / Line 9: @@
 !Description
 |-
+|'''Database'''
+|Select the reporting database.
 |}

Stanley.songok: /* Summary */

2025-10-01T13:17:06Z

Summary

← Older revision		Revision as of 15:17, 1 October 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities		The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities.

	== Filters ==		== Filters ==

Stanley.songok: /* Summary */

2025-10-01T13:15:45Z

Summary

← Older revision		Revision as of 15:15, 1 October 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	~~This is for the page "~~Weight v Revenue Week-On-Week" page ~~that~~ is a part of the Yield, Weight and Revenue GSA ~~Report~~.		The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities

	== Filters ==		== Filters ==

David.weller: Created page with " == Summary == This is for the page "Weight v Revenue Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

2025-09-30T10:19:33Z

Created page with " == Summary == This is for the page "Weight v Revenue Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

New page

== Summary ==
This is for the page "Weight v Revenue Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}