Pivot app query
Hi - I created a Pivot and then did a lot of customization on the Pivot so I don't want to lose it.
I updated it several times by tweaking the content in the source data and it still imported/refreshed ok.
Then tonight I renamed 2 column headers and then it broke.
I renamed them back to the original names and it still won't work.
I get error message;
Error! The columnId 7106294493538180 is included more than once in a single row. (1037)
Is this expected behavior?
When I created the pivot I created it by adding 1 value at a time as I was getting some errors, this got me around that challenge.
With the way the column mapping works - can I 'rebuild' the pivot using the existing source file to the existing destination file and it will use the same column mapping again? Or is there a risk that by re-adding values again it will cause new columns to be entered and undo all my prior work?
Hope that makes sense? Thanks!