Issue with Partial Sum Dynamic Label

[#1]

Hello All,

Let me summaries my requirement.

I have pivot with 2 columns  value and 1 row value, I want to make my label dynamic which changes in the List selection for the partial sum (for row), which I can do with Expression.

but it works only when I expand the data and goes back to TOTAL(Default) if I collapse it.

Can someone please help me how to solve my issue. Attaches in the sample qvw file.

Thanks & Regards,

MVV Satish.

[MK_QSL]

Properties >> Presentation >> Select FQ and >> Labels for Totals >> =GetFieldSelections(List)

[its_anandrjs]

Go to

Properties -> Presentation -> Select FQ Dimension -> Labels for Totals -> type a code

=if(GetSelectedCount(List)=1,GetFieldSelections(List),'Total')

because when you not select any thing it display '-'

[#4]

Thanks for the suggestion, but I don't want to change the label for the FQ

[#5]

Thanks for the suggestion, but I don't want to change the label for the FQ

[its_anandrjs]

For which column you required.

[nizamsha]

PFA

[#8]

For Country Column