Pivot Object Value should to disp

[sona_sa]

Hi,

I have a pivot object, Now when I am expending the object my Subtotal value is displaying, But when I collapse the same object, Total value is not displaying.

I need to do when I collapse the object, the bold one row should to display and rest of entire should to display irrespectively.

Please find the attached qvw for the same.

Regards,

QV

[giakoum]

there is an if in all your expressions that does not hold for the total expression

[sona_sa]

Hi Any try by Macro setting.