I have tried but not able to achieve the required solution,
can you please suggest something specific related to my current scenario.
Please post your workbook.
Thanks for the file.
Here is my approach attached in workbook v10.5.
First you need to pivot your three measures.
Conditional calculated field.
Set this as pane across.
Thank you for the reply,
The solution you have provided is working but it is impacting my rest of the worksheet because tableau giving the error in Actual Sales Value, Velocity & Wd(Max Column).
Is there any option where I can perform the pivot task in without changing my original source data?
My suggestion would be if this is just limited for this sheet then create a copy of original data source, pivot, and create only this view based on it. So, this way your other views wouldn't be affected.
Thank you for your suggestion,
Your suggestion really helped me a lot.
Just wanted to check with you that after the transformation of data we will get Pivot Names & Pivot value,
Currently, Tableau summarise all the data(Sales Val, Velocity & WD) to perform sorting
I'm trying to sort data on WD YTD_CY column.
Can you please let me know your thoughts regarding the same.
Screenshot for reference:
Sorting order is not proper