Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
Last time I posted to find a way to get the last row in a pivot table chart type as shown below
I got an answer in which the expression is as follows:
if(rank(total RowNo(total)) = 1, 'L')
That definitely was the correct expression but it was silly of me that I failed to notice this particular condition; while it correctly displayed the last row in the pivot table for a selected country, but when you select multiple country it will still indicate the last row of the pivot table and this is quite not the result I desire.
What I wanted is to show it like this
How do I tweak the expression so that it will display at the last row of each country selected and displayed in the pivot table? As pictured above?
Thank you for your kind attention guys
Hi Jagan,
Hmm it is working on yours but not mine.. really weird. And also silly me for not sharing the qvw file earlier.
Maybe you can have a look for me please?
Thank you so much for your kind attention
Please check this one:
=If(Country <> Below(TOTAL Country,1) and not IsNull(Country), 'L', '-')
Hi Dariusz,
It works! Thank you very much for you kind attention
Thank you again