Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have my data set as the below. Importing this table from SQL database.
I want to transpose the KPI field to columns like the below.
I tried generic load and concatenating, but its taking so much time to load the script and gets struck after a point of time. Are there any better ways to do it ?
Thanks for your help !
crosstable function
Load the data and use Pivot table.
Add Dim: Month and KPI
Add Expr: Sum(Value)
Then transform KPI by dragging on top of the expression value.