2 Replies Latest reply on Nov 27, 2018 10:17 PM by Nicole Cheong

    Adding more columns to a pivot after initial setup

    Nicole Cheong

      Hi there....new some advice on whether I can add more columns to an existing pivot after the initial data prep?

      As new categories are being created for a column which I have pivoted to flatten the data, I need to be able to add them when the data source changes at each refresh. Per screenshot below, Data Source is the Pivot and I want to add the first 2 columns into it.

       

      Am also connected to an Excel worksheet.

       

      Anyone has encounter this and have a solution?

      Much appreciated.