I have a work book and need to create pivot on one of the sheet. The sheet has a lot of columns. Pivot table should have data as : Rows = column1 and Values = Sum of (value in column 7).
I need to design it in Studio… I checked the create pivot table activity. But it doesn’t seems to be useful. The excel data is not in “Table”.
Please guide me for possible solution.