Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In attached example I want to see actual quarter like 'Q4-14' etc rather than stupid values. Can somebody help me please?
In Red is not sorted
Instead of 20,3,3,5,4 I need Q4-14, Q1-15 and so on
Thanks
Use this instead:
='1 is: ' & SubField(Concat(Values, '|', Qtr), '|', 1)
HTH
Best,
Sunny
Attaching your application for reference also.
Best,
Sunny
='1 is: ' & SubField(Concat(Values, '|',Qtr), '|',1)
='2 is: ' & SubField(Concat(Values, '|',Qtr), '|',2)
and so on
in addition to above, you may also need DISTINCT clause in concat: concat( distinct .... ) so that the values don't repeat for every row of data.