1 of 1 people found this helpful
Hi Chakradhar! One option you have is to calculate the minimum and maximum and then put them both on the Text or Labels mark. Then, edit the label itself and put them on the same line with a minus sign between them.
Thanks David.. This was helpful
You're welcome! If that worked for you, could you please mark it as correct so it no longer shows up as unanswered? Thanks!
I Have a similar problem. my values in one column like
I need output like
Column values can be changed, basically what I need is, we need display value range using the next row value.
Can any one help on this?
Thanks in advance!!
Hi Vamshi! You could try something like this:
IF LAST() > 0 THEN
STR(SUM([col1])) + "-" + STR(LOOKUP(SUM([col1]), 1) - 1)
STR(SUM([col1])) + "+"
This needs to compute along Table Down or col1.