Hey guys I'm having problem to achieve this. I have 5 columns ID,Product,Section, Sales,qty. I want Section Column values as a row.
Can anyone help me with this? Thanks in advance
Are you doing in script / Front end. If it front end you can drag your column to row and use 2 expressions like Sales, Qty ..
Use Pivot Table Chart,
In Rows, Use ID and Product Fields
In Columns, Use Section Field.
In Measures Section Use Sales Expression and Qty Expression
Retrieving data ...