Thanks for this video, it's really helpful. I do have a question though. I'm using a pivot table to calculate the number of days and hours I'm working on a clients projects, is there a way to get the grand total to know that 8hrs should be 1 day? Thanks
In Numbers, is it possible to force a pivot table to automatically update when the data changes? I’m new to this and just kinda teaching myself what I need to know along the way, and this is the first thing that’s stumped me so far. I’m creating a simple personal finance tracker, and I have a table for household utilities. The header column has check-boxes to be marked when the bill is paid. I want the “amount paid” to only be calculated into the “total paid” when the check-box is “true.” The only way I’ve been able to hack this so far is to make a pivot table for the data, but now I need to have it auto-update when I either edit the “amount paid” column, or the “paid” checkbox column.
@@ProlificOaktree Thank you. Is there a way to get the dates to filter by the year/quarter etc? When I added the date column the only options are for it be arranged in ascending or descending order, but no option to filter by year, quarter etc.
@@caraghabrielledorsett5460 You can GROUP and SORT by year/quarter, etc. but not filter. When you drag the date field into the Rows (for example) click on it and look at the Field options.
@@ProlificOaktree Just to be clear... once I click out of the pivot table, it is now just a standard "table" ... i.e. if I want to change the columns/rows/data sources I basically delete it and start over? 😰
Thank you very much. This is very helpful for me.
Glad it helped you out.
Thanks for this video, it's really helpful. I do have a question though. I'm using a pivot table to calculate the number of days and hours I'm working on a clients projects, is there a way to get the grand total to know that 8hrs should be 1 day? Thanks
Not that I know of.
In Numbers, is it possible to force a pivot table to automatically update when the data changes? I’m new to this and just kinda teaching myself what I need to know along the way, and this is the first thing that’s stumped me so far. I’m creating a simple personal finance tracker, and I have a table for household utilities. The header column has check-boxes to be marked when the bill is paid. I want the “amount paid” to only be calculated into the “total paid” when the check-box is “true.” The only way I’ve been able to hack this so far is to make a pivot table for the data, but now I need to have it auto-update when I either edit the “amount paid” column, or the “paid” checkbox column.
That sounds more like as SUMIF formula than a Pivot Table issue. A checkbox is TRUE when checked so SUMIF(A1=TRUE) to get the paid total.
Can you create a pivot table based on more than one table?
No, just one table.
Very interesting 💞
Will the pivot table still work if your data is center aligned?
Yes. Formatting of the source data would have no impact.
@@ProlificOaktree Thank you. Is there a way to get the dates to filter by the year/quarter etc? When I added the date column the only options are for it be arranged in ascending or descending order, but no option to filter by year, quarter etc.
@@caraghabrielledorsett5460 You can GROUP and SORT by year/quarter, etc. but not filter. When you drag the date field into the Rows (for example) click on it and look at the Field options.
Excelent
There is no "Create Pivot Table" option in the "Organise" drop-down menu. Is this because the file I am working with is a .CSV?
No there isn’t. CSV files can only contain a grid of values.
Is it possible to change the source?
No, you'll have to start over.
how do I edit the fields??? mine are locked in, and I can't change them?
You edit the source table, not the pivot table....if that helps.
@@ProlificOaktree Just to be clear... once I click out of the pivot table, it is now just a standard "table" ... i.e. if I want to change the columns/rows/data sources I basically delete it and start over? 😰
@@rpaulseymour A Pivot table stays dynamic. You should be good to go.
Pity. The segment introduced as “count” is not counting occurrences but summing the dollar values.
Oh, you're right. I'll change it!