Hi
I am able to use in built pivot function but I am unable to make one of my column as say quarter value Q1, Q2, Q3 as table header. The Pivot just performs group function but I need to transpose my table.
Thanks
Hi
I am able to use in built pivot function but I am unable to make one of my column as say quarter value Q1, Q2, Q3 as table header. The Pivot just performs group function but I need to transpose my table.
Thanks
Hi Isha,
Its a current limitation. Formula parser uses letter+digit combination for column cell reference.
e.g. c1,b2 , q6 etc.
Can you please try quarter values as Quarter1/2/3 ?
Thanks !
Anup
- AnupAhire
- 2013-11-21T20:05:46Z
Hi Isha,
Its a current limitation. Formula parser uses letter+digit combination for column cell reference.
e.g. c1,b2 , q6 etc.
Can you please try quarter values as Quarter1/2/3 ?
Thanks !
Anup
Hi Anup,
My original table has a column "Quarter" and the values stored under are 'Q1', 'Q2', 'Q3' and 'Q4'.
Now in the Pivot table I want to make 'Q1', 'Q2', 'Q3' and 'Q4' as column header. This is possible in excel and even in SQL Server.
But I want to implement same in BigSheets. Let me know if there any way to perform this.
Thanks
Isha