Conditional values in Sub total

[Anonymous]

I am relatively amatuer in PBI. Can you help me out in this complex issue?

I have a table like this below in PBI

Row Labels	Month	Campaign	Type	Revenue
2019
	01
		ABC
			Actual	$100
			Projected	$200
		ABC Total		$300
		DEF
			Actual	$300
			Projected	$400
		DEF Total		$700
	01 Total			$1,000
2019 Total				$1,000
Grand Total				$1,000

This is a standard pivot format. But what I want is that before the Month total, there should be 2 more subtotals - 01 Actuals Total and 01 Projected total. But these total should be outside of the campaigns. Something like below

Row Labels	Month	Campaign	Type	Revenue
2019
	01
		ABC
			Actual	$100
			Projected	$200
		ABC Total		$300
		DEF
			Actual	$300
			Projected	$400
		DEF Total		$700
	01 Actuals Total			$400
	01 Projected Totals			$600
	01 Total			$1,000
2019 Total				$1,000
Grand Total				$1,000

Can you help me in achieving this? Thanks in advance

- Shalini

[v-chenwuz-msft]

Hi @Anonymous,

There can only be one total in a layer, and you can put the Type into the columns of the matrix table to achieve the total method.

Or You can put your ideas on power bi ideas.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , That is only possible when Actual and Projected are measures and show on Row is used.