i have pivot produced through a pivottable macro. can we rename the column names just like we do in excel pivot
Hi @Nags Subramanian ,
Firstly gave you the hint in your previous question and then came across this one: wrap your Pivot Table macro in the Table Transformer macro and rename your columns as you wish:
SELECT T1.'Long column name coming from pivot' AS 'New beautiful name'
FROM T1
Hi @Janice ,
Please add some custom tags for us:
Thank you!
Thank you.
Hi, got stuck with an issue on this please. could you help.
Below is my first table using a table transformer macro. In this i have coloured the Story End column based on component status.
Below is the pivot table produced based on the above table with sort order as column headings. i need to bring in the component status since i need the coluring based on that column. hence each application is displayed on multiple lines based on status.
Now i applied a table transformer macro on top of this pivot to display the column names in more readable way.
2 issues:
1. How to show the dates grouped in one line for one application?
2. How to colour the date column based on the component status.
code currently used is as below:
SELECT T1.'ICTO', T1.'Application Name',min(T1.'Literal of Story End 1 - Design') as 'Design',min(T1.'Literal of Story End 3 - Onboard') as 'Onboard',min(T1.'Literal of Story End 4 - Test') as 'Test',min(T1.'Literal of Story End 5 - Deploy') as 'Deploy',min(T1.'Literal of Story End 6 - Cut over') as 'Cut over'FROM T1 group by T1.'ICTO', T1.'Application Name', T1.'Component Status'
any suggestions please !
It looks like you're new here. Sign in or register to get started.
