PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables RelationshipDelete row/column including table row/column
I've been searching the internet for quite a while now to find an answer to the following: I would like to know whether it is possible to delete an entire row/column which also is part of a table. If I try this now, the error message appears: 'it is not possible to delete this row/column now'. Hope that there is a genius who knows an answer to this riddle. Johan.
How do I group rows in an excel table?
I'm creating an excel table to keep a tab of patients' payments made on their visits. The problem I am having is that some patients have multiple visits so they have multiple rows in the table, but I don't have their name listed repeatedly. So for example, their name is listed in A1, and their visits are listed in D1 and D2, but their name is not listed again in A2. When I try and sort or filter the table, only the visit listed in D1 gets sorted with the patient name. How do I get these grouped together to where if I sort alphabetically, the multiple visits (rows) get sorted too? I have included a picture of the problem. Thank you!
