How to get a column based on another derived column
Please refer the below image where i have created a sequence number (Sno) for WeekID.
I have a straight table (below) where i have dynamically created a dimension which buckets the selected weeks into group of 4 using the sequence number of the Week. Now i have the sequence number in the column (based on the WeekIDs selected). How do i show the WeekID or WeekDesc corresponding to it.
For e.g. in the below straight table example, I want to show the WeekID (or WeekDesc) corresponding to the Sno 8,12,16 displayed.
Thank you for your response, but there is a small issue with that approach.
In the dynamic dimension expression (as shown in the image previously) I have used a class function which created buckets of four Sequence numbers(Sno), and extracted the highest Sno (using Subfield function) and wanted to replace it with WeekID or WeekName.
But the if() condition replaces the bucket with the Week dimension as a result the Expression is calculated on the Week Level instead of a 4 week rolling sum.