teddy0bear
New Member
- Joined
- Aug 26, 2016
- Messages
- 4
Hello world.
I've created a lovely query from a SharePoint list which is working very nicely but I'm having troubles getting a pivot table to display the results I want.
Simplified version of query returns:
<tbody>
</tbody>
Easy.
What I'm trying to get is:
<tbody>
</tbody>
What I'm getting instead is:
<tbody>
</tbody>
It does make sense what it's doing, it's saying that of those 2 opened in January 2 of them have been closed. Helpful, but I don't want that. I want it to count ALL those closed in January and not be limited by those created in January. The month created and closed dates are data fields instead of text.
This is a pretty simple table, and I could just do a formula instead but I need to add a slicer to it and possibly some other things so I need to keep it as a pivot table.
Do I have to some how break the relationship? Or do I have to tell it somehow that January = January and it should store things under there instead..?
I've created a lovely query from a SharePoint list which is working very nicely but I'm having troubles getting a pivot table to display the results I want.
Simplified version of query returns:
| Created | Closed |
| 1/1/2016 | 1/28/2016 |
| 1/2/2016 | 2/20/2016 |
| 2/24/2016 | 3/18/2016 |
<tbody>
</tbody>
Easy.
What I'm trying to get is:
| Month | Created (count) | Closed (count) |
| Jan | 2 | 1 |
| Feb | 1 | 1 |
| March | 1 |
<tbody>
</tbody>
What I'm getting instead is:
| Month | Created (Count) | Closed (Count) |
| Jan | 2 | 2 |
| Feb | 1 | 1 |
<tbody>
</tbody>
It does make sense what it's doing, it's saying that of those 2 opened in January 2 of them have been closed. Helpful, but I don't want that. I want it to count ALL those closed in January and not be limited by those created in January. The month created and closed dates are data fields instead of text.
This is a pretty simple table, and I could just do a formula instead but I need to add a slicer to it and possibly some other things so I need to keep it as a pivot table.
Do I have to some how break the relationship? Or do I have to tell it somehow that January = January and it should store things under there instead..?
