Spreadsheet: 836415d1689333719-add-dual-value-to-pivot-table-and-or-power-bi-matrix-visual-pivot-multiplier
Sheet: Sheet1

Project | Sub-Project | Project Level Multiplier | Sub Project Level Multiplier | Month
70009205 |  | 5.668857594959928 | 5.410500000000001 | 202301
70009205 | 70009205-105 | 5.668857594959928 | 6.24 | 202301
70009205 | 70009205-106 | 5.668857594959928 | 4.581 | 202301
70009205 |  | 5.668857594959928 | 5.410500000000001 | 202302
70009205 | 70009205-105 | 5.668857594959928 | 6.24 | 202302
70009205 | 70009205-106 | 5.668857594959928 | 4.581 | 202302 |  |  |  |  |  | Column Labels
70009205 |  | 6.66885759495993 | 5.410500000000001 | 202303 |  |  |  |  |  | 202301 |  | 202302 |  | 202303 |  | Total Average of Project Level Multiplier | Total Average of Sub Project Level Multiplier
70009205 | 70009205-105 | 6.66885759495993 | 7.24 | 202303 |  |  |  |  | Row Labels | Average of Project Level Multiplier | Average of Sub Project Level Multiplier | Average of Project Level Multiplier | Average of Sub Project Level Multiplier | Average of Project Level Multiplier | Average of Sub Project Level Multiplier
70009205 | 70009205-106 | 6.66885759495993 | 4.581 | 202303 |  |  |  |  | 70009205 | 5.668857594959928 | 5.410500000000002 | 5.668857594959928 | 5.410500000000002 | 6.66885759495993 | 5.743833333333335 | 6.002190928293262 | 5.521611111111111
70009206 |  | 4.66885759495993 | 5.410500000000001 | 202301 |  |  |  |  | 70009205-105 | 5.668857594959928 | 6.24 | 5.668857594959928 | 6.24 | 6.66885759495993 | 7.24 | 6.002190928293262 | 6.573333333333333
70009206 | 70009205-105 | 4.66885759495993 | 6.24 | 202301 |  |  |  |  | 70009205-106 | 5.668857594959928 | 4.581 | 5.668857594959928 | 4.581 | 6.66885759495993 | 4.581 | 6.002190928293262 | 4.581
70009206 | 70009205-106 | 4.66885759495993 | 4.581 | 202301 |  |  |  |  | (blank) | 5.668857594959928 | 5.410500000000001 | 5.668857594959928 | 5.410500000000001 | 6.66885759495993 | 5.410500000000001 | 6.002190928293262 | 5.410500000000002
70009206 |  | 3.66885759495993 | 5.410500000000001 | 202302 |  |  |  |  | 70009206 | 4.66885759495993 | 5.410500000000002 | 3.66885759495993 | 5.410500000000002 | 7.66885759495993 | 5.743833333333335 | 5.335524261626596 | 5.521611111111111
70009206 | 70009205-105 | 3.66885759495993 | 6.24 | 202302 |  |  |  |  | 70009205-105 | 4.66885759495993 | 6.24 | 3.66885759495993 | 6.24 | 7.66885759495993 | 7.24 | 5.335524261626596 | 6.573333333333333
70009206 | 70009205-106 | 3.66885759495993 | 4.581 | 202302 |  |  |  |  | 70009205-106 | 4.66885759495993 | 4.581 | 3.66885759495993 | 4.581 | 7.66885759495993 | 4.581 | 5.335524261626596 | 4.581
70009206 |  | 7.66885759495993 | 5.410500000000001 | 202303 |  |  |  |  | (blank) | 4.66885759495993 | 5.410500000000001 | 3.66885759495993 | 5.410500000000001 | 7.66885759495993 | 5.410500000000001 | 5.335524261626596 | 5.410500000000002
70009206 | 70009205-105 | 7.66885759495993 | 7.24 | 202303 |  |  |  |  | Grand Total | 5.16885759495993 | 5.410500000000002 | 4.66885759495993 | 5.410500000000002 | 7.16885759495993 | 5.743833333333335 | 5.668857594959929 | 5.521611111111111
70009206 | 70009205-106 | 7.66885759495993 | 4.581 | 202303
 |  |  |  |  |  |  |  |  | ProjectMultiplier |  | Month
 |  |  |  |  |  |  |  |  | Project | Sub-Project | 202301 | 202302 | 202303
 |  |  |  |  |  |  |  |  | 70009205 | (blank) | 5.410500000000001 | 5.410500000000001 | 5.410500000000001
 |  |  |  |  |  |  |  |  |  | 70009205-105 | 6.24 | 6.24 | 7.24
 |  |  |  |  |  |  |  |  |  | 70009205-106 | 4.581 | 4.581 | 4.581
 |  |  |  |  |  |  |  |  | 70009205 Total |  | 5.668857594959928 | 5.668857594959928 | 6.66885759495993
 |  |  |  |  |  |  |  |  | 70009206 | (blank) | 5.410500000000001 | 5.410500000000001 | 5.410500000000001
 |  |  |  |  |  |  |  |  |  | 70009205-105 | 6.24 | 6.24 | 7.24
 |  |  |  |  |  |  |  |  |  | 70009205-106 | 4.581 | 4.581 | 4.581
 |  |  |  |  |  |  |  |  | 70009206 Total |  | 4.66885759495993 | 3.66885759495993 | 7.66885759495993