Are you stuck on Excel or Google Sheets?

I want to only count unique instances of an array in a pivot table. For example client A has been invoiced twice for Product B and 3 times for Product C. I want to count the fact that Client A has used Product B and Product C ( ie a value of 1 for each) and not 2 for A and 3 for B

How can I set up a pivot table to show "count of" totals by year across different columns (instead of just filtering year by year)

I have a pivot table with data points per month and I am putting that into a spreadsheet (a budget). My problem is that I can't figure out to escalate each data point per column, i.e. ='Pivot Table 1'!E3 then the next column pulls from ='Pivot Table 1'!E4, the next ='Pivot Table 1'!E5...SO, how do I write a formula the right way?

I added data to my table. Ive refreshed the pivot table but when I access "builder" within the table, I don't see my new column listed.

I have a problem on creating a bubble chart from a pivot table.