Pivot App - Dynamic Updating
I'm trying to create a Pivot Chart using the pivot app based on a number of sheets in a workspace. As it doesn't allow me to pivot on data from a workspace i have created a report, this works and i'm able to pivot on that data.
The problem i have is when i pivot on the pivot sheet it has created a row called grand total. I need to allow the Chart to update automatically if any additional lines of data are added and can only do that if i select all rows.
This brings through the Grand Total Column but i don't want to reflect that in my charts.
How do I remove that row from the Pivot Sheet?
Also is there a link to the Engage 19 Pivot App session?