Topic
  • 2 replies
  • Latest Post - ‏2013-12-02T16:51:54Z by chaudis
chaudis
chaudis
11 Posts

Pinned topic BigInsights BigSheets Pivot Table

‏2013-11-20T18:00:53Z |

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

  • AnupAhire
    AnupAhire
    2 Posts

    Re: BigInsights BigSheets Pivot Table

    ‏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

  • chaudis
    chaudis
    11 Posts

    Re: BigInsights BigSheets Pivot Table

    ‏2013-12-02T16:51:54Z  
    • 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