Hi
I hope someone can help
I have a set of data layed out in columns. Example data attached.
| Project Number | Department | Partner | Status | In Plan / Out of Plan | Value |
| 1 | Dept 1 | Partner 1 | On Time | In | £14.00 |
| 2 | Dept 2 | Partner 2 | Delayed | Out | £3.00 |
| 3 | Dept 3 | Partner 3 | Delayed | Out | £18.00 |
| 4 | Dept 1 | Partner 1 | Delayed | In | £22.00 |
| 5 | Dept 2 | Partner 2 | On time | In | £104.00 |
| 6 | Dept 3 | Partner 3 | On Time | In | £19.00 |
| 7 | Dept 1 | Partner 1 | Delayed | Out | £25.00 |
| 8 | Dept 2 | Partner 2 | On Time | In | £3.00 |
| 9 | Dept 3 | Partner 3 | Delayed | In | £28.00 |
| 10 | Dept 1 | Partner 1 | Delayed | Out | £4.00 |
What I would like is a table where the Department and Partner columns can be used as slicers for the whole data set, but the count of: Status; Launch; Value columns are tabulated independent of each other.
I attached an example of what I would like the end point to be
| Pillar or Partner | Status | In Plan | Value |
| All | | | |
| Dept 1 | | | |
| Dept 2 | | | |
| Dept 3 | | | |
| Partner 1 | | | |
| Partner 2 | | | |
| Partner 3 | | | |
Thanks for your help
Matt
