So I have made a slice of a table.
The set up looks like the picture below.
How it is shown is exactly how I want to view the information.
All the totals for the plants on one sheet.
However, the totals that are there are the totals that were calculated with the numbers from the entire original table, not the slice.
I want a total of #'s JUST for the slice, not the whole sheet.
The whole point is that it will show how many plants my crew needs to put into their car at the beginning of the day for 3-5 clients that they are going to.
So it’s just those clients included in the slice, and now I need the totals to reflect that slice.
Can’t find anywhere to add a virtual column or anything like that to the slice, that would be pretty cool though as a future function (hint, hint).
When I go to the UX view of the slice and select COUNT for the group aggregate, again it counts the total from the original sheet, not the slice.
How do I get where I need to go???
Help is very very much appreciated. Thanks, Miranda