Display last value in range instead of total

[#1]

Hi All,

I have a pivot table that represents number of donors by segment and month (see the attachment).

On this pivot table for Active donors in total I want to display the last Month Value instead of total.

Is it possible?  Please Help.

Thanks

[#2]

Hi Michael,

Thanks for your help.

Unfortunately the expression gives me zeros when I use it.

However when I change SecondaryDimensionality to Dimensionality it gives me numbers under Months but nothing in total

Do you have any ideas why.

Thanks a lot for your help.

Denis

[#3]

Hi all.

Is there anybody who can help me with this issue?

Any help would be much appreciated.

Thanks.

Denis

[Anonymous]

Hi

please read the following , I am not sure whether it relates to or not ..

thanks to gwassenaar

Display most recent record in text box

https://community.qlik.com/message/1086065#1086065

[settu_periasamy]

Hi Denis,

Can you post the sample qvw instead of excel?

[#6]

Hi Settu,

Can you kindly let me know how to attach qvw file?

The only attachment options I could find are image, video or link.

Thanks

[settu_periasamy]

When you do the reply, in top right corner, there is an option 'Use advanced editor'.

After clicked that, you can see the attach option in the same window

[#8]

I do not have that option on my screen?

[Anil_Babu_Samineni]

Instead of this, What are you expecting

[Anil_Babu_Samineni]

Please check that, In the Right Corner you can see. After that click and down right side you will get Attach Then click and then Upload your File

[settu_periasamy]

i think you are replying from your inbox. you need to click your link.

Display last value in range instead of total