Questions tagged [excel-pivot]
48 questions
0
votes
2 answers
Excel pivot condition cell
how can i set condition inside pivot sum data to refer label row ?
I need to sum data only if row label is equal to specific value.
I'm trying to use standard IF but it doesn't work.
Thanks.
enfix
- 6,680
- 12
- 55
- 80
-1
votes
1 answer
Show intersection values across excel file
I have table with around 8000 rows .
This is just example of that :
I need to show the intersection values across the column Co. For example , I need to show a result like this :
To describe the result . It looks to the table and show how many No…
algisy123
- 17
- 1
- 8
-3
votes
1 answer
Excel Pivot Table - how to arrange fields to sum a field while ignoring duplicate rows from another unrelated field
I hope someone can help me figure out what I'm doing wrong here - maybe it's my lack of Pivot table knowledge or even how the data is being modelled.
I am creating a report from an MS Access database query. I have simplified the data for the…
AFraser
- 3
- 1