Hi chriswin ,
Try this solution:
https://community.sisense.com/t5/build-analytics/transposing-pivot-table/m-p/2274
-Hari
Hi chriswin ,
Try this solution:
https://community.sisense.com/t5/build-analytics/transposing-pivot-table/m-p/2274
-Hari
Does this process take the whole table and unions it to itself for each metric? For example, if a table has 5,000 rows and 3 metrics, the result would be a table with 15,000 rows?
No, you need to create a table of matrices with fake key and create a custom column 'key' in transaction table. When you create a widget, you will get duplicate rows for each matric. Then apply the formula as mentioned in the below post with case statement:
-Hari
