Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Year and Quarter data in a table along with amount. (See the attached .qvw file). I want to show the year and quarter as shown in the output. Any idea ?
Thanks
This is what I have in a pivot table:
But the output should be as below:
Combining them into one should not be a problem
Feeling lazy to do the second part. Can you take this forward?
What don't you try using the Pick(Dim(...)) approach? Have you already tried it?
Thought of it but then I have two separate dimensions and felt it is not possible... Any samples..?
Thanks
Combining them into one should not be a problem
Feeling lazy to do the second part. Can you take this forward?
Here you go
This is exactly what I was doing and I saw your response.. I will take this to the next step and see..
Thanks
Hi Sunny,
Can you elaborate how this Dim worked after the last value of the dimension
Kiran Kumar