Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Properties >> Presentation >> Select FQ and >> Labels for Totals >> =GetFieldSelections(List)
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 '-'
Thanks for the suggestion, but I don't want to change the label for the FQ
Thanks for the suggestion, but I don't want to change the label for the FQ
For which column you required.
PFA
For Country Column