Change Total Formula in pivot table based on dimensionality

[inessa_zhurba]

I need to have Totals calculated as 2018 Q4 - 2018 Q3 etc...

I included the following formula into calculation using set Analysis , but it doesn't look like it works - it is still displays the total for both quarters:

=If(Dimensionality()=0 , sum({<BillingQuarterNumber={"$(=max([BillingQuarterNumber] ))"}>}[Amount Billed]),
sum([Amount Billed]))

Then I was trying to use after function - it doesn't work as well!!

=If(Dimensionality()=0 , after(sum([Amount Billed]),2) - after(sum([Amount Billed]),1) ,
sum([Amount Billed]))

I am not sure what I am doing wrong here!

I appreciate any help!

Thanks,

Inessa.