Subtotal is not showing for calculated dimension

[ashis]

Hi,

I have one calculated dimension in my pivot table for which I am not getting subtotal. Nothing is showing in the subtotal.

my dimension expression is like the following;

=aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB)

Please help,

Thank you,

[Anil_Babu_Samineni]

This?

=Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

[ashis]

Hi ,

Thank you for your quick reply, I am getting error in calculated dimension .

Thank you,

[Anil_Babu_Samineni]

Calculated Dimension won't give any subtotal. Still you need, You may calculate same expression in expression section to use Dimension Label