I don't know how to splite YYYY-MM to MM
My data is from SQL server,
so it looks like this as below
I want to do like this .
welecome to have any suggestion.
Hi Jerry Chen ,
Select your field on columns and rows both .
So here you can see moth selected and select year for columns and you will get what you are looking for .
In case you will stuck somewhere please share your twbx file or workbook .
but My Month is with Year like this
You are selecting other month .Please check .
If you are not getting this share your twbx file .
Here is my approach.
Let me know if that helps or not.
Hi, My data is from SQL server, so my dimention is like this, I think it is unlike yours.
so I cannot use split,
Retrieving data ...