Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
This?
=Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))
Hi ,
Thank you for your quick reply, I am getting error in calculated dimension .
Thank you,
Calculated Dimension won't give any subtotal. Still you need, You may calculate same expression in expression section to use Dimension Label