Hi friends, could you help me about this?
Can I rename a column in cross table like the example below? (I rename it with dates)
My table is like this :
You may consider using the "Insert->Transformation" option.
Under the "Transformations" tab you can use the "Pivot" function.
You can refer the below screenshots of the sample dataset which I tried for achieving your requirement:
This is the Pivot operation from "Insert->Transformation":
Your expected output:
To achieve the exact outcome as in your screenshot, you can remove the Amount column from the data table properties:
The data table after all the above operations shall be :
I hope this is the expected data table that you want to achieve.
Thank you Rohit, i really appreciate your answer.
In the custom expression for the cross table, you can use "as" after the column element and then your desired column name "[Column name]".
For example: [ColumnElement] as [19-October-2017].
Not sure from the data table exactly which column you are trying to rename?
However, from the data table, it seems you need to transform your data:
You may consider Pivoting and Unpivoting the data from the "Insert->Transformations" to achieve your desired table.
You can find detailed information in the below documentation:https://docs.tibco.com/pub/sfire-analyst/7.10.1/doc/html/en-US/TIB_sfire...
Hi. Thank you for the explanation. I really appreciate it.
What i am trying to do is :
If flag = 1 then show column name as its date (19-Oct-2017), if flag=2 then column named as 20-Oct-2017 ... and so on.
Is it possible?
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer