I have a table already created which is pulled from an excel data source. Using the values in table , I want to add some calculated rows to th exiting table . Is there a way to do it ?
Solved! Go to Solution.
My table has multipe columns , few with calculated percentages . I have been using the unpivot and pivot functions to add rows and apply certain data transformations . When I finally unpivot the data of the data, I lose the transformation applied on the % columns . Is there a way I retain the transformation of the columns when I unpivot them .