Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
6 years ago
Solved

Dynamic Piviot

Hello,

 

I have a single table with 5 columns COL1, COL2, COL3, COL4, COL5, Table has over 500,000 rows.

 

I have a slicer on COL1, now Based on value selected by users in COL1, I want to show

 

COL1, COL2, COL3, COL4, and COL5 Values across (Pivot)

 

So, IF Values of COL1 selected to be A, then there might be only 10 columns going across for COL5

 

Is it possible?