|
|
|
|
#1
02-23-2023, 02:08 PM
|
||||
|
||||
the @ means refer to the same row in that column.
Without the @ refers to whole column. You can see it when you edit the formula in the formula bar (the formula parts are highlighted in the same colour as the boxes around the ranges): 2023-02-23_210650.png You don't need to type these references in. If you use the mouse to select ranges while you're building the formula, they will appear automatically. 
|
|
#2
02-23-2023, 03:31 PM
|
|||
|
|||
|
Many Thanksp45cal
I understand the formula now, but I'm struggling with the pivot table. How did you calculate the percentages. The only way I could find to do it was to create another pivot table and calculate from there (see attached)
|
|
#3
02-23-2023, 03:43 PM
|
||||
|
||||
|
Quote:
2023-02-23_223931.png Right-click somewhere in the values area of the pivot (column G in my file, column K in your latest file) and choose Value field settings…
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pivot chart for multiple data sets | md0627 | Excel | 1 | 01-08-2023 05:17 PM |
| Can we update Chart in PPT based on a table in the excel and the table is part of the Chart Data | nareshj | PowerPoint | 0 | 07-12-2018 02:29 PM |
| Copying a Chart Linked to a Pivot Table | coma08 | Excel | 1 | 06-07-2017 08:24 PM |
| Combine multiple tables into one pivot table in order to do trend analysis | marelisev | Excel | 2 | 04-15-2017 08:30 AM |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Windows 10 
Office 2019
Hybrid Mode